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?

1 1156

What are its different types of dbms?

1 1069

What are the best features of mongodb?

1 12

How long does replica set failover take?

1 10

Does an update fsync to disk immediately?

1 10

When will data be on more than one shard?

1 11

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

1 8

How do you see the connections used by mongos?

1 11

What is 32-bit nuances?

1 12

What is a secondary or slave?

1 11

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

1 12

Why are data files so large?

1 10

What are the disadvantages of mongodb?

1 12

Can journaling feature be used to perform safe hot backups?

1 11

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

1 12

Un-Answered Questions { Databases }

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

List out the different types of locks available in sql server?

1037

Can you index views?

946

What is the difference between case version and decode version?

1091

Design database draw er diagram for a certain scenario ?

4635

How to Change a users password from unix shell.

1193

what is spatial nonclustered index

1047

Can we rollback truncate?

1057

What are the different SQL Server Versions you have worked on?

1071

How to enter binary string literals in ms sql server?

1231

How to convert numeric expression data types using the cast() function?

1133

Have you written applications to retrieve stored images in a table?

1070

What is current version of mysql?

1057

How to convert character strings into numeric values?

1166

What versions of clipper does netlib support?

1062

For More Un-Answered { Databases } Questions Click Here