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 is the main difference between sql and pl/sql?

1154

What are its different types of dbms?

1061

What are the best features of mongodb?

How long does replica set failover take?

Does an update fsync to disk immediately?

When will data be on more than one shard?

Is it required to call ‘getlasterror’ to make a write durable?

How do you see the connections used by mongos?

What is 32-bit nuances?

What is a secondary or slave?

Can the old files in the ‘movechunk’ directory be removed?

Why are data files so large?

What are the disadvantages of mongodb?

Can journaling feature be used to perform safe hot backups?

Will there be journal replay programs in case of incomplete entries (if there is a failure in the middle of one)?

Un-Answered Questions { Databases }

What is a procedure in pl sql?

1292

What are the differences between stored procedure and view in sql server?

1326

What is difference between ms sql and mysql?

1018

how do you add a developer to a trusted publishers list?

893

What is sql server query analyzer?

1105

What is 2nf in database?

1084

How do I create an access database from excel?

985

What's the difference between file and database? Can files qualify as a database?

1028

What is the difference between left and left outer join?

999

Can we use views in stored procedure?

1089

How to insert and update data into a table with "insert" and "update" statements?

1053

What is a ctid?

946

What is variable? What is Flow of variable?

670

Benefits of Stored Procedures?

1047

Can procedure in package be overloaded?

1147

For More Un-Answered { Databases } Questions Click Here