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

Is left join faster than join?

1096

Does inner join remove duplicates?

996

Can we rollback after truncate?

1072

Can we create a trigger on view?

945

Does truncate release storage space?

1135

Are views faster than queries?

1038

Can we perform dml on view?

1115

How does a trigger work?

1144

Can we insert delete data in view?

998

How does a covering index work?

1008

Can we have two clustered index on a table?

1078

How many types of primary keys are there?

1078

Can we insert data into view?

949

How do you define a foreign key?

1063

Can we join tables without foreign key?

1006

Un-Answered Questions { Databases }

How many TRIGGERS are allowed in MySql table?

1130

What are logical/boolean operations in ms sql server?

1102

How do I quit mysql?

985

What is the usage of ENUMs in MySQL?

1180

Explain the purpose of oracle real application clusters (rac)?

How is clustered database important in oracle rac architecture?

How can you do replication?

What is having clause in sql?

1018

what is self-join? : Sql dba

1239

Why are function needed?

1001

What is %rowtype in pl sql?

1030

What is the synonym of join?

1016

How to drop an existing view in mysql?

965

How do I start mongodb?

tell us something about heap tables. : Sql dba

1142

For More Un-Answered { Databases } Questions Click Here