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?

853

Does truncate need commit?

895

How do you create a unique index?

992

How do I create an index in word?

968

Do we need commit after truncate?

1034

How many unique keys can a table have?

959

Does indexing improve query performance?

1 1173

Does normalization improve performance?

982

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

872

Do we need to create index on primary key?

858

How many columns should be in an index?

905

How is indexing done in search engines?

930

How many subqueries can be nested in a statement?

935

How many clustered indexes can you have?

927

How do you explain an index?

1224

Un-Answered Questions { Databases }

How to create table show example

905

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Explain about sybase 365?

816

What are the different types of join?

1104

How to delete a database from mysql server.

989

Explain what stored procedure sp_replcounters is used for? : sql server replication

1455

How to delete/drop an existing postgresql database?

841

Explain datetime2 data type in sal server 2008?

857

What do you understand by mirroring and mention the advantages of the mirroring?

1009

What is the advantage of varchar2 over char?

1214

What is a business logic layer?

763

Explain index covering? List its merits.

880

What is mysql server used for?

894

What is database transaction?

819

what is Single Byte Overhead...?

2500

For More Un-Answered { Databases } Questions Click Here