Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 a data dictionary and how can it be created?

1244

Why do we need integrity constraints in a database?

1080

What are the different responsibilities of a dba?

780

How can we tune a sql query to optimize the performance of a database?

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

What is rac?

What is table partitioning and why is it required?

What is table partitioning?

What is an explain plan and how does it help in optimizing the sql query?

What is a recovery catalog?

How is incremental backup different from differential backup?

What do you understand by row chaining?

What is tkprof and how can we use it?

How can a single instance environment be converted into rac environment and how will they be different?

What do we mean by hot backup & cold backup and how are they different?

Un-Answered Questions { Databases }

Does mongodb use javascript?

What is blob in mysql?

1092

What is cube dimension? : sql server analysis services, ssas

1050

how to analyze tables with 'mysqlcheck'? : Sql dba

1066

How can we store rows in PL/SQL using array?

1272

What is cost in sql execution plan?

1049

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2458

Is mongodb file based?

Define phantom deadlock.

1095

What is gridfs in mongodb?

What are different types of data models available? Explain with example?

1182

How many types of functions are there in sql?

1011

What is database or database management systems (dbms)?

1010

What is the purpose of -> in the mysql terminal?

1182

Can sql server 2016 run on windows 7?

967

For More Un-Answered { Databases } Questions Click Here