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

Define concurrency control. : Transact sql

1 1255

What is pessimistic concurrency control? : Transact sql

1 1154

How to use transactions efficiently : transact sql

1 1133

Explain locks? : Transact sql

1 1081

What is the least restrictive isolation level? : Transact sql

1 1131

What is optimistic concurrency control? : Transact sql

1 1054

What is the most restrictive isolation level? : Transact sql

1 1157

Explain isolation levels. : Transact sql

1 1128

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

1 1054

what is the primary use of the model database? : Sql server administration

1 1117

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

1 1021

which table keeps the locking information? : Sql server administration

1 1159

what is a mixed extent? : Sql server administration

1 1209

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

1 1055

where can you add custom error messages to sql server? : Sql server administration

1 1199

Un-Answered Questions { Databases }

Equi join and non equi join is possible with sql server?

1126

how many tables will create when we create table, what are they? : Sql dba

1140

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1186

What are the two main functions of queries in databases?

1522

what are the advantages of sql ? : Sql dba

1136

how to escape special characters in sql statements? : Sql dba

1110

What is the difference between upgrade and migration in sql server?

1175

what is the difference between openrowset and openquery?

1186

How can we solve concurrency problems?

1120

Can we use distinct and group by together?

1130

List the ways in which dynamic sql can be executed?

1079

Have you written applications to retrieve stored images in a table?

1083

what are all the common sql function? : Sql dba

1125

How did mongodb get its name?

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

For More Un-Answered { Databases } Questions Click Here