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

1167

Why do we need integrity constraints in a database?

1040

What are the different responsibilities of a dba?

737

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 }

Can mongodb store structured data?

What you can use regular expression for in mysql?

953

What is input buffer in sql*plus?

1243

What command do you type to exit the postgresql console application?

865

What is difference between order by and group by?

1020

How to specify default values in insert statement using oracle?

1119

Why having clause is used in sql?

990

Which database is best for storing large data?

912

Could you please let me know the interfaces in OM / FA??

2278

What is primary key secondary key alternate key candidate key?

1045

what is the difference between Delete and Truncate command in SQL

1162

how many sql dml commands are supported by 'mysql'? : Sql dba

1137

explain commit and rollback in mysql : sql dba

1031

Why I have to use stored procedures?

1066

In which format data is stored in mysql database?

1005

For More Un-Answered { Databases } Questions Click Here