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

Explain the terms database and dbms?

928

Mention the different types of dbms.

1029

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

971

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

860

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

1177

Mention the differences between union and union all

925

what are the different integrity rules present in the dbms?

990

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

966

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

1000

Mention a query to add email validation to your database

929

what are the differences between network and hierarchical database model?

1130

Mention how deadlock can be resolved?

967

What is index hunting?

1205

When does checkpoint occur?

897

What is an entity-relationship model?

947

Un-Answered Questions { Databases }

What are the purposes and advantages stored procedure?

961

How to pipe multiline string to isqi?

what is raid? : Sql server database administration

1049

What is Service Broker in sql server 2012?

1027

What is bcnf normalization form?

1125

What is the first step in creating a database?

894

What is the trigger in sql?

966

who conceived and designed the informix database management system?

Why use triggers?

1020

What is pg_toast?

808

How do you delete a table?

1087

Can you explain full-text query in sql server?

1018

How do I kill a query in postgresql?

1145

What are the types of database users?

1003

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1020

For More Un-Answered { Databases } Questions Click Here