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 }

List out the difference between neo4j graph database and mysql database?

Are there any features that are decommissioned in 11g that are not present in 11g?

2148

What is postgresql client?

945

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2254

What is the cartesian product of the table?

958

how to enter characters as hex numbers? : Sql dba

1041

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1631

How do I create a database in pgadmin 4?

802

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

971

What you mean by Object Relational DBMS?

1053

Define clusters?

1080

What are functions in sql?

955

How do you remove duplicate records from a table?

940

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

How to turn off warning messages during php execution?

1044

For More Un-Answered { Databases } Questions Click Here