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

Is left join faster than join?

1057

Does inner join remove duplicates?

945

Can we rollback after truncate?

1033

Can we create a trigger on view?

901

Does truncate release storage space?

1083

Are views faster than queries?

993

Can we perform dml on view?

1047

How does a trigger work?

1076

Can we insert delete data in view?

954

How does a covering index work?

969

Can we have two clustered index on a table?

1025

How many types of primary keys are there?

1040

Can we insert data into view?

907

How do you define a foreign key?

1008

Can we join tables without foreign key?

965

Un-Answered Questions { Databases }

Please illustrate physical database architecture? : SQL Server Architecture

990

Does table partitioning improve performance?

973

Explain a data segment?

1071

What are the ways to tune reporting services?

1004

Explain the first normal form(1nf)?

1030

What is report server project?

148

What is the difference between pre-select and pre-query?

1222

Explain the different types of constraints?

948

How to get / select the nth row from the table?

In mysql, what is joins? Explain

971

How can we remove orphan records from a table?

988

What are the different types of triggers?

1138

How big is a blob mysql?

893

Explain do view contain data?

1016

What is a recovery catalog?

For More Un-Answered { Databases } Questions Click Here