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 do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Why do we use materialized view instead of table or views?

How can we use tkprof?

How would you identify the shared_pool_size parameter that needs to be adjusted?

How can we collect the statistics of different database objects?

What do you understand from cache fusion?

Why do we need to rebuild indexes?

What is the difference between media recovery & crash recovery?

What are the different types of backups that are available in oracle?

What are the different tools that are provided by oracle to assist performance monitoring?

What is the difference between restoring a database and recovering a database?

Can you list down the different components of physical and logical database structure?

What do you understand by redo log file mirroring?

What do you mean by sga and how is it different from pga?

What is a flashback query and when should it be used?

Un-Answered Questions { Databases }

What is a coalesce function?

1206

How is mongodb data stored?

how to enter binary numbers in sql statements? : Sql dba

987

What are the four objectives of the selection of a data type?

938

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1029

What is an agent and What are the types of agents?

641

What if your ocr (oracle cluster registry) is corrupted?

What is data types in ms access?

915

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1084

What is a database lookup?

1109

How you will show all data from a table.

1003

What are the key characteristics of rac or why to use rac?

What are the objects can be created using CREATE statement?

1003

What is coalesce in sql server?

1067

Why and when do stored procedure recompile?

997

For More Un-Answered { Databases } Questions Click Here