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

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 6371

What is BCP? When do we use it?

2 10418

What should we do to copy the tables, schema and views from one SQL Server to another?

3 9366

What are the different types of joins and what does each do?

2 8313

What is a sub-query? When would you use one?

3 14550

What are three SQL keywords used to change or set someone?s permissions?

3 16543

What is referential integrity? What are the advantages of it?

Descon, Digital Domain,

4 31539

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18966

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

eFunds,

5 17400

What is a trigger?

7 9283

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

Accenture, Merrill Lynch, Wipro,

2 16155

What is an execution plan? When would you use it? How would you view the execution plan?

1 6499

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 11047

What are the different types of replication? How are they used?

3 13287

What is the difference between a local and a global variable?

5 40647

Un-Answered Questions { Databases }

Explain what is lock escalation and what is its purpose?

988

what happens if you no create privilege in a database? : Sql dba

1050

What is a design view?

981

Can a database be shrunk with users active?

1196

How many types of cursors supported in pl/sql?

1266

What is the difference between clustered and non-clustered indexes in ms sql server?

1060

Is there any link between pr form(purchse requisition)and po form(purchase order)

2795

how mysql optimizes distinct? : Sql dba

1131

Can I download microsoft access for free?

878

What is the difference RDBMS and Graph Database?

1095

How to execute postgres function in pgadmin?

1114

How is a developer added to a trusted publishers list?

890

What is database management system with example?

1083

What is n tier architecture in dbms?

997

Difference between data and information, and how are they related in a database?

1028

For More Un-Answered { Databases } Questions Click Here