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

Explain the terms database and dbms?

987

Mention the different types of dbms.

1107

What are indexes? Mention the differences between the clustered and non-clustered index?

1025

What do you understand by functional dependency and transitive dependency in dbms?

927

What do you understand by proactive, retroactive and simultaneous update?

1216

Mention the differences between union and union all

971

what are the different integrity rules present in the dbms?

1055

Mention a query to calculate the even and odd records from a table

1020

what are the differences between an exclusive lock and a shared lock?

1058

Mention a query to add email validation to your database

974

what are the differences between network and hierarchical database model?

1179

Mention how deadlock can be resolved?

1005

What is index hunting?

1252

When does checkpoint occur?

936

What is an entity-relationship model?

989

Un-Answered Questions { Databases }

How to run queries on external tables?

1092

What are the characteristics of database?

942

What are functions in sql?

1000

What is normalization in dbms?

977

What is spatial and temporal data?

1050

What can I use instead of union in sql?

1024

What is the difference between online clustering and Offline clustering?

2486

What is SQL Azure?

107

Does windows server 2016 come with sql server?

986

What is the new security features added in sql server 2016? : sql server security

1168

How do I enable remote access to postgresql database?

874

What do you mean by a deadlock?

1116

Explain the term entity set in dbms?

1196

What are the differences between a dbms and rdbms?

1068

What is an intersect?

1157

For More Un-Answered { Databases } Questions Click Here