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 term entity in dbms?

902

What is index hunting and how does it help in improving query performance?

1996

What do you understand by clause in sql?

1034

What are the differences between a dbms and rdbms?

998

Explain the terms specialization and generalization.

959

Explain the term entity set in dbms?

1152

Explain the term entity type in dbms?

1016

What are the different types of keys in the database?

951

Mention the different languages present in dbms

962

What is sql and where is it used?

953

What do you understand by cursor?

950

How can you perform pattern matching in sql?

1005

What do you understand by intension and extension?

923

Mention the differences between unique key and primary key

969

What is normalization and what are the different types of normalization?

991

Un-Answered Questions { Databases }

What is the difference between oracle and MS Access?

1078

What is sharding in mongodb?

How to create software using microsoft access?

964

what are database files and filegroups? : Sql server database administration

953

List some of the products of sybase.

883

what are defaults? : Sql server database administration

1100

How to create dbo table in sql server?

963

What do you mean by an execution plan?

1122

When would you use the stored procedures or functions?

1008

how to load data files into tables with 'mysqlimport'? : Sql dba

1103

How to commit the current transaction in oracle?

1130

How to add code to the existing article (using improve article)?

1117

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2725

Explain entity ?

1041

What are the most important characteristics of pl/sql?

1169

For More Un-Answered { Databases } Questions Click Here