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

Explain the terms database and dbms?

987

Mention the different types of dbms.

1115

What are indexes? Mention the differences between the clustered and non-clustered index?

1035

What do you understand by functional dependency and transitive dependency in dbms?

934

What do you understand by proactive, retroactive and simultaneous update?

1218

Mention the differences between union and union all

976

what are the different integrity rules present in the dbms?

1058

Mention a query to calculate the even and odd records from a table

1024

what are the differences between an exclusive lock and a shared lock?

1060

Mention a query to add email validation to your database

976

what are the differences between network and hierarchical database model?

1182

Mention how deadlock can be resolved?

1012

What is index hunting?

1252

When does checkpoint occur?

941

What is an entity-relationship model?

996

Un-Answered Questions { Databases }

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1075

How to pump the data from one database to another?

978

Explain indexed views?

1038

What is the default sql server instance name?

1098

How to reaname table name without using sp_Rename in sql server..?

1043

What are database states in ms sql server?

1259

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

970

What are horizontal and vertical scaling?

172

Difference between Logical Page and Physical Page in SSRS.

493

How to insert multiple rows with one insert statement in oracle?

1143

What are instead of triggers?

1105

Is mongodb object oriented?

How do you create type- insensitive operator?

1113

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1701

What do you understand by lov and how can it be used?

1159

For More Un-Answered { Databases } Questions Click Here