Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What is sql*loader and what is it used for?

1153

What are the triggers associated with image items?

1042

What is bind reference and how can it be created?

1020

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1100

What are the datatypes available in pl/sql ?

1104

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1075

How many clustered indexes can be created on a table?

1075

What is raid? How does it help storage of databases?

1087

Explain about recursive stored procedures?

802

Explain about the implementation of business logic in stored procedures?

729

Explain about the process which takes place to execute a stored routine?

748

What is the difference between a user defined function and a stored procedure?

866

Explain about the return statement?

880

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

846

What are external procedures ? Why and when they are used?

847

Un-Answered Questions { Databases }

How to save array of objects in mongoose?

Can postgresql scale horizontally?

919

Differentiate between syntax and runtime errors.

1191

What is varray in pl sql?

1075

How many types of indexes are there in mysql?

914

What happens when the default and temp tablespace clauses are left out from create user statements?

575

What is normalization? Describe its different types.

1105

What is the difference between flex mode and confined mode?

1052

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1943

How to name query output columns in oracle?

1187

How to show all tables with 'mysql'?

1005

What are the execution control statements?

1065

How do you know if your mysql server is alive?

1075

What are types of indexes in sql?

1082

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2010

For More Un-Answered { Databases } Questions Click Here