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

Can unique keys be null?

858

Does truncate need commit?

902

How do you create a unique index?

998

How do I create an index in word?

976

Do we need commit after truncate?

1042

How many unique keys can a table have?

969

Does indexing improve query performance?

1 1186

Does normalization improve performance?

991

How can you tell the difference between an index and a view?

877

Do we need to create index on primary key?

864

How many columns should be in an index?

913

How is indexing done in search engines?

938

How many subqueries can be nested in a statement?

946

How many clustered indexes can you have?

932

How do you explain an index?

1231

Un-Answered Questions { Databases }

What is the contrast amongst drop and truncate?

991

what is the difference between primary key and unique key? : Sql dba

987

Mention the differences between sql server and mysql.

962

What is an identity column in insert statements?

978

Explain cursor types?

965

Explain what is mysql?

991

What is the maximum no of columns a table can have?

872

What is the xml datatype?

1007

Write a query to fetch common records between two tables using mysql?

975

Can we insert in view in sql?

1010

What is normalization sql?

1006

What are scalar functions?

958

What is the full form of mysql?

965

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1050

What are the parts of microsoft access?

852

For More Un-Answered { Databases } Questions Click Here