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 fill factor concept mean with respect to indexes?

974

Explain the term specialization.

911

What do you understand by correlated subqueries in dbms?

1023

Mention few case manipulation functions in sql

1047

what are the acid properties in dbms?

1077

What are the differences between hash join, merge join and nested loops?

1073

Explain the term generalization.

1053

What is concurrency control?

1110

What do you understand by sub-queries in sql?

997

What is a deadlock and mention how it can be resolved?

917

Write a query to remove duplicate rows from a table?

952

Write a query to create a duplicate table with and without data present?

914

Explain database partitioning and its importance.

1047

Mention the differences between the clustered and non-clustered index

963

write a query to retrieve the last day of next month in oracle.

995

Un-Answered Questions { Databases }

How many types of table create in ms access?

867

Is foreign key required?

801

Why do you want to join software field as you have done your BE in Electronics?

2201

What is an intersect?

1157

What is foreign key violation?

911

What is triggers?

1010

How raid can influence database performance?

1091

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1015

What is query execution plan in sql?

1253

Which data type columns are the best candidates for full-text indexing?

1028

Is pgadmin free?

833

How to query multiple tables jointly?

1044

What is the bookmark lookup and rid lookup?

1037

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1209

Alternative to row at a time processing in sybase?

842

For More Un-Answered { Databases } Questions Click Here