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

997

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

1002

What is optimistic concurrency?

1097

Explain what are the events recorded in a transaction log?

1055

What is pessimistic concurrency?

1028

Do you know the isolation level that sql server support?

1005

Explain optimistic and pessimistic concurrency?

1039

Explain the various types of concurrency problem?

1246

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

1151

What is sql server locking?

1036

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

1018

Explain the benefits of user-defined functions?

1127

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

940

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

1050

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

1028

Un-Answered Questions { Databases }

Can the query output be sorted by multiple columns in oracle?

1061

What is an advantage of a database?

1111

What are the characteristics of database?

942

HOW TO SPOT AHIERARCHY?

2351

What are the different types of database objects?

1124

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1319

What are the 5 r's of managing behaviors?

1140

how to use myisamchk to check or repair myisam tables? : Sql dba

1020

what is error ora-03113: end-of-file on communication channel?

1233

describe and contrast a trigger and a procedure.

1109

Can you get microsoft access for free?

920

What are sql azure firewall rules?

106

What are the different types of modeling?

953

What are the IKM types?

741

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2401

For More Un-Answered { Databases } Questions Click Here