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

How many primary keys can a table have?

961

Does truncate remove indexes?

978

How can we find duplicate records in a table?

900

Can we insert data in view?

898

How do I remove all records from a table?

1040

Why truncate is faster than delete?

1062

Are subqueries faster than joins?

957

Does truncate free space?

953

Can a foreign key be null?

1037

How do you respond to dementia behavior?

934

Can we create clustered index without primary key?

908

How many types of index are there?

977

Is primary key an index?

956

How do you optimize a query?

943

Is natural join same as inner join?

876

Un-Answered Questions { Databases }

How do I delete a table in postgresql?

800

How to set database to be read_only in ms sql server?

962

What are the advantages of ms access?

806

What is reportserver and reportservertempdb ?

146

What is triggers?

921

Do you know what is sql service broker?

1003

What are different types of statements that are supported by sql?

989

What is the default schema of your login session in ms sql server?

996

How to install mongodb on our machine?

What do data architects do?

776

how to see the create table statement of an existing table? : Sql dba

954

How many database files are there in sql server 2000?what are they?

983

What is dml with example?

1017

What is an artificial (derived) primary key? When should it be used?

843

What do you understand by coalesce in sql server?

1009

For More Un-Answered { Databases } Questions Click Here