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 8318

What is the use of Control File ?

3 6599

What is a Data Dictionary ?

5 8350

What is an Integrity Constrains ?

3 7241

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

2 7790

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8176

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7388

Describe Referential Integrity ?

1 5345

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

1 5619

What is self-referential integrity constraint ?

SunGard,

2 14561

What are the Limitations of a CHECK Constraint ?

5 19348

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

3 9127

What is normalization?

9 12992

What is a Stored Procedure?

8 12529

Can you give an example of Stored Procedure?

Wipro,

4 11338

Un-Answered Questions { Databases }

Explain about reporting services of MYSQL?

1080

Explain multiserver query

1057

How do I edit a stored procedure in sql server?

935

What is difference between inner join and self join?

1095

What is clr ddl trigger?

988

How to convert characters to dates in oracle?

1112

What happens if null values are involved in bitwise operations?

1044

What is the full meaning of dml?

964

How would you use user_constraints table in DB?

1017

Explain what stored procedure sp_replcounters is used for? : sql server replication

1533

What are the differences between triggers and stored procedures?

1080

What does innodb stand for?

981

What is a null value in access?

902

Which constraints we can use while creating database in sql?

1092

What is the maximum database size for sql express?

1042

For More Un-Answered { Databases } Questions Click Here