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?

1095

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?

1038

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?

1125

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?

1026

Un-Answered Questions { Databases }

How to list all triggers in the database with sys.triggers in ms sql server?

1142

How are a file stored in neo4j?

Why does mysql have so many connections?

950

What is the difference between a delete command and truncate command?

1041

What is a business logic layer?

849

What are sub reports?

208

What is data model in database?

946

How to update info already in a table and delete a row(s) from a table.

918

what is timestamp in mysql? : Sql dba

1133

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1014

What is data modelling techniques?

903

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1089

What are the types of variable use in pl sql?

1140

What are foreign key constraints?

941

How to select all columns of all rows from a table with a select statement in ms sql server?

1202

For More Un-Answered { Databases } Questions Click Here