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 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 covering index?

1048

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1968

What are the sql versions?

1004

Explain partial key?

1146

What is heap table in mysql?

1019

Is mongodb for big data?

Write a query to remove duplicate rows from a table?

952

what is IDE,DMV in sql server?

2885

How do I setup a sql server database?

1131

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1050

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2196

How do I install and use mysql?

1002

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2383

Please explain joins in oracle?

1112

What are the two main functions of queries in databases?

1500

For More Un-Answered { Databases } Questions Click Here