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 are the different types of lock modes in sql server 2000?

957

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

961

What is optimistic concurrency?

1051

Explain what are the events recorded in a transaction log?

1015

What is pessimistic concurrency?

988

Do you know the isolation level that sql server support?

974

Explain optimistic and pessimistic concurrency?

1002

Explain the various types of concurrency problem?

1205

Do you know what are the differences between lost updates and uncommitted dependencies?

1098

What is sql server locking?

1001

Do you know what guidelines should be followed to help minimize deadlocks?

985

Explain the benefits of user-defined functions?

1076

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

918

Explain how dts is used to extract, transform and consolidate data?

1011

Explain the difference between functions and stored procedures in sql server?

995

Un-Answered Questions { Databases }

What is the use of for clause?

1133

Does mysql use sql?

903

What are different clauses used in sql?

1128

What is mysql routine?

950

What is a string data type in sql?

1049

how to calculate expressions with sql statements? : Sql dba

1048

What is pdo connection?

890

What is an Integrity Constrains in Oracle?

1197

Explain important index characteristics?

1051

What are the types of database engines available in mysql?

1050

can you tell how can you display the maximum salary in sql? : Mysql dba

873

Define model database?

990

Does windows 10 have microsoft access?

849

How do you create a blank database?

956

Explain the difference between sql and mysql.

1071

For More Un-Answered { Databases } Questions Click Here