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 8412

What is the use of Control File ?

3 6732

What is a Data Dictionary ?

5 8517

What is an Integrity Constrains ?

3 7350

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

2 7934

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8249

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7511

Describe Referential Integrity ?

1 5422

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

1 5676

What is self-referential integrity constraint ?

SunGard,

2 14657

What are the Limitations of a CHECK Constraint ?

5 19496

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

3 9236

What is normalization?

9 13222

What is a Stored Procedure?

8 12748

Can you give an example of Stored Procedure?

Wipro,

4 11473

Un-Answered Questions { Databases }

How to get nth highest salary from table in a mysql?

998

What is 3nf normalization form?

1172

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1052

How we can see all indexes defined for a table in mysql?

1002

How to drop an existing user defined function in ms sql server?

1070

Which statement is used in a select query for partial matching?

1232

what is profile in odi?

701

What are the 4 types of database?

1072

Explain tablesample?

1044

What is the difference between $lt and $lte?

What is metadata in dbms?

1017

How to maintain a fill factor in existing indexes?

1059

What is cursors?

1264

Who owns sybase?

901

What is storage encryption?

For More Un-Answered { Databases } Questions Click Here