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 the difference between a primary key and a unique key? : Sql server database administration

1015

what are isolation levels? : Sql server database administration

1006

what is normalization? Explain different levels of normalization? : Sql server database administration

1340

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1143

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1046

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

935

what are user defined datatypes and when you should go for them? : Sql server database administration

1030

what are constraints? : Sql server database administration

1070

what is the difference between delete table and truncate table commands? : Sql server database administration

1054

what is the information that can be stored inside a bit column? : Sql server database administration

974

how to avoid cursors? : Sql server database administration

983

what is the maximum size of a row? : Sql server database administration

1029

what are the disadvantages of cursors? : Sql server database administration

1041

what is a transaction? : Sql server database administration

1004

what are candidate key, alternate key and composite key? : Sql server database administration

927

Un-Answered Questions { Databases }

How you find which the latest record in SCD type2 transformation is?

591

Is access database still used?

859

How to select some specific rows from a table in ms sql server?

1018

Describe an oracle table?

1062

How to declare and use cursor variables?

1187

What is meant by Active-Passive and Active-Active clustering setup?

1189

Why is the use of dbms recommended? Explain by listing some of its major advantages.

1703

How to detect the server version?

1092

What are the hotfixes and patches in sql server?

1030

Is there a free version of mysql?

953

What are the features of rdbms?

868

Write a trigger example in oracle?

1076

What is ODI console?

675

Is access good as a database?

861

Explain Geometry datatype in sql server 2008 with example

1002

For More Un-Answered { Databases } Questions Click Here