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

What is self contained sub query?

1080

What is a scheduled job or what is a scheduled task?

971

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

988

What is clustered index

1024

Disadvantages of the indexes?

1144

Equi join and non equi join is possible with sql server?

1036

What are the different acid properties?

1085

When multiple after triggers are attached to sql table, how to control the order of execution?

1064

How to find out the list schema name and table name for the database?

948

What is serializable?

1051

What is save transaction and save point?

1221

Explain transaction isolation levels in sql server?

1139

Explain multiserver query

1062

How to remove duplicate rows from table?

1268

What is a hint?

1015

Un-Answered Questions { Databases }

What is a procedure in pl sql?

1228

Explain database link?

1136

What is the use of floor function in sql server?

1097

What is the use of procedure in mysql?

953

What is concurrency control?

1041

What is the purpose of indexing?

1060

What is difference between clustered and non clustered index?

999

What is 1nf 2nf?

1020

What is data model in database?

902

What is oracle sid?

964

List the data types available in mssql?

1050

How ssrs maintain security?

1101

Can an extended stored procedure be called from inside a user-defined function?

1086

What do you mean by foreign key and primary key?

1056

What is function of ROLLUP ?

1103

For More Un-Answered { Databases } Questions Click Here