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

Oracle (3253)
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 does a Control file Contain ?

2 8419

What is the use of Control File ?

3 6737

What is a Data Dictionary ?

5 8520

What is an Integrity Constrains ?

3 7356

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 7935

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8249

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7512

Describe Referential Integrity ?

1 5424

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 5678

What is self-referential integrity constraint ?

SunGard,

2 14660

What are the Limitations of a CHECK Constraint ?

5 19499

What is the maximum number of CHECK constraints that can be defined on a column ?

3 9237

What is normalization?

9 13233

What is a Stored Procedure?

8 12757

Can you give an example of Stored Procedure?

Wipro,

4 11487

Un-Answered Questions { Databases }

What packages are available to pl/sql developers?

1115

What are parameter files? Where do we use them?

What are the database objects? : SQL Server Architecture

1099

Is mongodb cloud based?

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

1228

What happen when an index does not fit into ram?

What is a scalar function?

1052

What is the usage of synonyms?

1221

Where do we use trace frag?

1066

How to use like conditions?

1045

How do you create a module in microsoft access?

1007

How would you check the long running transaction?

977

What does n tier mean?

789

How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?

1066

How do I show all mysql databases?

1023

For More Un-Answered { Databases } Questions Click Here