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

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1139

How to find the service pack installed? : sql server database administration

1038

What are recommended options to be used while using db mirroring? : sql server database administration

1178

What is service broker? : sql server database administration

1010

How to find the version of sql server? : sql server database administration

1126

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1154

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1008

Where sql server user names and passwords are stored in sql server? : sql server database administration

1079

According to you what goes into making the best database administrator? : sql server database administration

992

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1286

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

996

What is replication with database mirroring? : sql server database administration

1098

What is your recommendation for a query running very slow? : sql server database administration

1064

What is stored in the mssqlsystemresource database? : sql server database administration

1045

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1170

Un-Answered Questions { Databases }

Explain how to close periods in ar. : oracle accounts receivable

1335

What are access modules?

789

How can you load multi line records? : aql loader

1094

How do you declare a variable in pl sql?

1042

How to reorder the table columns (fields)?

1109

What is latest version of mysql?

1044

Is postgresql is nosql?

902

A single operation is failing to escalate?

845

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

1496

What are the 4 main objects of a database?

989

What are the operators in sql?

1042

Why are indexes and views important to an organization?

972

What to perform pattern match with the like operator?

900

What is offset limit?

974

What does top operator do?

1039

For More Un-Answered { Databases } Questions Click Here