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 “unrepeatable reads”?

1266

What is an execution plan? How would you view the execution plan?

1093

What is the cpu pressure?

1062

What is user defined stored procedures?

958

What is sql server schema compare? How we can compare two database schemas?

1048

What are pessimistic lock and optimistic lock?

1098

What is table constraint?

1005

What is sqlcmd?

1078

Explain activity monitors

1096

What is after dml trigger?

1032

What is dirty read?

1102

What is temporary table in sql server? Why we use temp table?

961

what is spatial nonclustered index

1003

Explain system functions or built-in functions? What are different types of system functions?

996

What is standby servers? Explain types of standby servers.

1007

Un-Answered Questions { Databases }

What are the operating modes in which database mirroring runs? : sql server DBA

1203

What is rowid in sql?

1011

What is meant by raw datatype?

1085

Explain an exception and its types?

1094

What is a system database and what is a user database?

1102

How are the exceptions handled in sql server programming?

1074

somehow informix fails to go online. Is there a way to view what oninit is doing?

Explain query editor regions

1064

Describe concurrency control.

1052

What are the four components of a database system?

874

How to enable tcp/ip protocol on a sql server?

1183

What is database white box testing?

1138

What are the string functions in sql?

991

what is a materialized view? : Sql dba

1076

What is the difference between postgresql and sql?

847

For More Un-Answered { Databases } Questions Click Here