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?

986

What are the differences between ms sql server & oracle?

1122

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

1037

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

997

What is the command dbcc checkdb used for?

1074

Can you name a few encryption mechanisms in sql server?

996

What are subqueries in sql server?

1197

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

1160

what do you understand by change data capture?

1084

Mention the different types of triggers?

1217

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

1230

Explain the properties of subqueries in sql server?

1144

How do you start single user mode in clustered installations?

990

What are the differences between sql server and mysql.

1152

Mention the different types of replication in sql server.

1076

Un-Answered Questions { Databases }

Why do we use function in pl sql?

1114

Enlist the cursor types.

1096

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2298

What is difference between two tier and three tier?

903

define join and explain different type of joins? : Sql dba

1002

what is a view? : Sql dba

1139

Other than truncate statement, which other command can by-pass the trigger on the tables?

1198

What is database write application of database?

962

How do I set up postgresql?

925

What are the tools available in market as an alternative to sql server reporting services?

138

Does truncate need commit?

1008

Differentiate between delete and truncate.

1117

Should you normalize audio?

1010

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1195

What is truncate in mysql?

1013

For More Un-Answered { Databases } Questions Click Here