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 is transact-sql ddl trigger?

1121

What is read committed?

1117

How do we know if any query is retrieving a large amount of data or very little data?

990

What is the maximum size per database for sql server express?

1067

What are basics of policy management?

1121

What is user-defined scalar function?

979

What are different types of collation sensitivity?

1008

What are “phantom rows”?

1678

Explain error and transaction handling in sql server?

1029

Difference between primary key and clustered index?

1022

How many columns can we include on clustered index ?

1008

What is a covered index?

951

Why can there be only one clustered index and not more than one?

1019

How to Check if table exists in sql server?

1151

How does using a separate hard drive for several database objects improves performance right away?

949

Un-Answered Questions { Databases }

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

1089

What are the types of index in sql?

1085

What is the difference between a shared lock and exclusive lock?

1134

What is raid and what are different types of raid configurations? : sql server architect

940

Which database is good for large data?

1007

What is the default fill factor value? : sql server DBA

1147

How can we remove orphan records from a table?

1003

What are user defined functions?

1026

How does an execution block start and end in pl sql?

962

What does mysql_fetch_assoc do?

972

What is data compression? : sql server database administration

991

How to update values on multiple rows in oracle?

1055

What is a dbms wizard?

1033

What are the dmvs? : sql server database administration

1082

What stored by the msdb?

1016

For More Un-Answered { Databases } Questions Click Here