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

Define concurrency control. : Transact sql

1207

What is pessimistic concurrency control? : Transact sql

1101

How to use transactions efficiently : transact sql

1072

Explain locks? : Transact sql

1024

What is the least restrictive isolation level? : Transact sql

1084

What is optimistic concurrency control? : Transact sql

998

What is the most restrictive isolation level? : Transact sql

1100

Explain isolation levels. : Transact sql

1079

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

992

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

1065

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

969

which table keeps the locking information? : Sql server administration

1111

what is a mixed extent? : Sql server administration

1129

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

998

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

1137

Un-Answered Questions { Databases }

Can pl sql procedure have a return statement?

1045

What are internal user account in oracle?

1025

What do you understand by ‘atomicity’ and ‘aggregation’?

929

What is an application role and explain a scenario when you would use one?

1028

What the different types of Replication and why are they used?

1091

How many null values we can have in a unique key field in sql server?

971

What are database connection details?

1180

How to analyze tables with 'mysqlcheck'?

1221

Is mongodb a firebase?

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

993

What are sql functions? Describe in brief different types of sql functions?

1117

what is commit? : Sql dba

1089

What are the logical operations?

1139

Explain the truncate command? : sql server architect

859

What is unsigned int in mysql?

963

For More Un-Answered { Databases } Questions Click Here