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 does fill factor concept mean with respect to indexes?

930

Explain the term specialization.

861

What do you understand by correlated subqueries in dbms?

970

Mention few case manipulation functions in sql

986

what are the acid properties in dbms?

1027

What are the differences between hash join, merge join and nested loops?

1011

Explain the term generalization.

987

What is concurrency control?

1031

What do you understand by sub-queries in sql?

955

What is a deadlock and mention how it can be resolved?

869

Write a query to remove duplicate rows from a table?

893

Write a query to create a duplicate table with and without data present?

866

Explain database partitioning and its importance.

987

Mention the differences between the clustered and non-clustered index

904

write a query to retrieve the last day of next month in oracle.

941

Un-Answered Questions { Databases }

why do foreground writes decrease performance ?

List some alternatives to mongodb?

Is truncate autocommit in oracle?

1094

How do you remove a foreign key constraint?

814

explain advantages of myisam over innodb? : Sql dba

1074

Where are SQL server users names and passwords are stored in sql server?

1277

What is the term match in mongodb?

Describe the functionalities that views support.

1111

How does mongodb replication work?

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1927

How run sql*plus commands that are stored in a local file?

1070

What is an Oracle Data Block?

1079

Which profile required to access Models in Designer tool?

714

How to get a list of all background sessions in the database?

994

Can we have two clustered index on a table?

1029

For More Un-Answered { Databases } Questions Click Here