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 single-user mode?

1 995

What are the differences between ms sql server & oracle?

1 1127

What part does database design plays a role in performance of an sql server-based application?

1 1041

What do you understand by replication in sql server? Mention the different types of replication in sql server.

1 1000

What is the command dbcc checkdb used for?

1 1078

Can you name a few encryption mechanisms in sql server?

1 1000

What are subqueries in sql server?

1 1206

What is the purpose of update statistics and scope_identity() function?

1 1172

what do you understand by change data capture?

1 1091

Mention the different types of triggers?

1 1234

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 1238

Explain the properties of subqueries in sql server?

1 1160

How do you start single user mode in clustered installations?

1 991

What are the differences between sql server and mysql.

1 1155

Mention the different types of replication in sql server.

1 1076

Un-Answered Questions { Databases }

How to write a left outer join with the where clause in oracle?

1136

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2081

Why and when do stored procedure recompile?

1042

How to export data from database and import into another?

978

what is the difference between openrowset and openquery?

1174

Is it possible to have clustered index on separate drive from original table location?

1026

Why should you use or avoid select * statements?

1094

How can you append an identity column to a temporary table?

1050

What are the properties of the transaction?

1059

How raid can influence database performance?

1093

what is the command syntax for inserting a document?

What is a view in sql?

1033

How to enter binary string literals in ms sql server?

1231

How do I find query history in sql server?

1000

What is subquery? Explain the properties of a subquery?

1046

For More Un-Answered { Databases } Questions Click Here