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?

1053

Does inner join remove duplicates?

941

Can we rollback after truncate?

1031

Can we create a trigger on view?

895

Does truncate release storage space?

1077

Are views faster than queries?

992

Can we perform dml on view?

1044

How does a trigger work?

1071

Can we insert delete data in view?

950

How does a covering index work?

960

Can we have two clustered index on a table?

1025

How many types of primary keys are there?

1038

Can we insert data into view?

901

How do you define a foreign key?

1003

Can we join tables without foreign key?

962

Un-Answered Questions { Databases }

Describe the types of keys?

1108

Does a dba have to file taxes?

583

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1005

What is a scenario in odi?

576

what are the different index configurations a table can have? : Sql dba

996

How to rename a table?

1020

If you see statistics that deal with "undo" what are they really talking about?

653

What are different types of data models available? Explain with example?

1106

How to get a list of columns in a view using the "sp_columns" stored procedure?

1041

what is a self join? : Sql server database administration

1041

What is the usage of synonyms?

1143

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

990

Does sql support programming?

1070

What is the purpose of foreign key constraints?

843

Explain what is a column in a table?

1107

For More Un-Answered { Databases } Questions Click Here