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

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 6271

What is BCP? When do we use it?

2 10287

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

3 9249

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

2 8212

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

3 14416

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

3 16429

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

Descon, Digital Domain,

4 31377

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18720

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

eFunds,

5 17233

What is a trigger?

7 9111

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 16029

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

1 6430

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

2 10952

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

3 13159

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

5 40491

Un-Answered Questions { Databases }

Explain the importance of partitioning.

993

Explain what is a database?

1091

What is normalisation in sql?

1068

Why truncate is ddl command?

1071

What is the difference between locking and multi-versioning?

995

Is it possible to configure the cache size for mmapv1 in mongodb?

write an sql query to find names of employee start with 'a'? : Sql dba

1037

What is the difference between delete and truncate statement in sql?

1080

What is the stuff?

1010

How to use order by with union operators in ms sql server?

1028

Explain the use of inctype option in exp command.

1038

Explain replica set?

How do I disable mysql?

941

What is the insert?

902

What is an example of a foreign key?

984

For More Un-Answered { Databases } Questions Click Here