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

What are the advantages of log shipping?

1014

Why are views required in the sql server or in any other database?

981

List the different index configurations possible for a table?

942

Where sql server usernames and passwords are stored in a sql server?

1002

List the various tools available for performance tuning?

899

What is a heap?

1047

Can we take the full database backup in log shipping?

968

What are the 2 types of classifications of constraints in the sql server?

1139

What is an execution plan?

1174

What are the different types of columns types constraints in the sql server?

1096

What is the stored procedure?

1021

What are the advantages of the mirroring?

1109

What are the common performance issues in sql server?

938

What are the purposes of using enum and set data types?

950

Describe mysql transaction properties.

1032

Un-Answered Questions { Databases }

What is a scheduled job or what is a scheduled task?

967

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1100

How to select some columns from a table in oracle?

1108

How to view tables in a database in postgresql?

864

Which sql server table is used to hold the stored procedure scripts?

1075

Explain about the database management systems.

984

Explain oracle data types with examples?

1043

Is sql a database?

938

What's the difference between mysql and sql server?

1000

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

997

Are connections to sql server encrypted?

1019

What is bind variable in pl sql?

1070

What is table partitioning in sybase?

911

What are the new features of sql server 2008 r2 reporting service?

212

What is meant by referential integrity?

1024

For More Un-Answered { Databases } Questions Click Here