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 does a Control file Contain ?

2 8306

What is the use of Control File ?

3 6578

What is a Data Dictionary ?

5 8333

What is an Integrity Constrains ?

3 7225

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

2 7771

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8164

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7375

Describe Referential Integrity ?

1 5335

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

1 5607

What is self-referential integrity constraint ?

SunGard,

2 14545

What are the Limitations of a CHECK Constraint ?

5 19326

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

3 9116

What is normalization?

9 12975

What is a Stored Procedure?

8 12510

Can you give an example of Stored Procedure?

Wipro,

4 11315

Un-Answered Questions { Databases }

What are key constraints?

978

Name the different type of indexes in sql?

967

Is microsoft access included in office 365?

824

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1026

How to import one table back from a dump file?

1027

How to rebuild the master database?

1083

Does oracle database need java?

1013

How do I change global variables in mysql?

907

What is the difference between mongodb and mongoose?

How fixed length strings are truncated and padded?

980

How sql server enhances scalability of the database system?

1221

Is mysql same as mariadb?

911

What is federated tables in mysql?

912

Can we insert data in view oracle?

1044

Explain the difference between mysql and mysql interfaces in php?

1098

For More Un-Answered { Databases } Questions Click Here