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

1103

What are its different types of dbms?

1010

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 are the different sql commands?

1078

Explain the advantages of rdbms?

936

What is resource governor in sql server?

1007

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

974

Explain mutating triggers.

1034

Does oracle use sql?

935

How to run pl sql program in mysql?

1026

How to update values in a table with update statements in ms sql server?

1016

What stored by the master?

955

How to install oracle sql developer?

1055

What are the 'mysql' command line arguments?

1017

How do you run a query in pgadmin 3?

752

what is an extended stored procedure? : Sql server database administration

1063

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

605

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1514

For More Un-Answered { Databases } Questions Click Here