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 is the role of tables in database?

961

What is the use case where we can use stretch database?

932

How many rows can a database hold?

1041

What is the difference between shrink database and shrink file?

884

What is flag in database?

1011

How do you performance tune a database?

944

How do queries work in a database?

1020

What are sql server procedures?

979

How many types of built in functions are there in sql server 2012?

926

Why use stored procedures in sql server?

1013

Why do we use stored procedures in sql server?

939

What is stretch database in sql server?

1064

How to populate a table in sql server?

962

How many types of local tables are there in sql server?

930

How to get the query of a table in sql server?

898

Un-Answered Questions { Databases }

List some comparisons operators used in mysql?

987

What is a mongodb cluster?

How to get last inserted id after insert data from a table in mysql?

982

Explain multiserver query

1042

Why normalisation is required?

947

What are different types of queries in sql?

1121

What is tableplus?

883

What is cursor and its types?

1071

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

If you are not sure what command does a particular unix function what is the best way to determine the command?

565

How can I improve throughput in sybase?

925

Explain the order of sql statement execution?

1045

what are the performance and scalability characteristics of mysql? : Sql dba

996

What do you mean by super key, primary key, foreign key and candidate key?

973

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1249

For More Un-Answered { Databases } Questions Click Here