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

Is subquery faster than join?

1027

What are hotfixes and patches?

965

What are the methods of filing?

961

Is primary key is clustered index?

1008

What are the benefits of stored procedures?

1093

What is normalisation and its types?

1017

Is primary key clustered or nonclustered?

1033

Is the primary key an index?

1038

What are different types of indexes?

1023

What are the three forms of normalization?

1056

What are the advantages of indexing?

1004

What is rownum?

997

What are the types of keys?

1012

What kind of join is join?

988

What is index example?

1019

Un-Answered Questions { Databases }

How does database replication work?

1014

What is normalization in dbms?

949

Is access a good database?

814

Does view store data in sql?

975

What does (*) mean in sql?

961

Compare join and subquery in performance?

969

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

545

Explain cross join or cartesian product in sql?

904

which tcp/ip port does sql server run on? : Sql dba

1036

What is scrollable cursor?

1055

What is a field name?

990

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1224

What is oracle datasource?

1006

Explain the dirty pages?

1020

What is the most common trace flags used with sql server?

1066

For More Un-Answered { Databases } Questions Click Here