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 6279

What is BCP? When do we use it?

2 10301

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

3 9257

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

2 8225

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

3 14428

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

3 16443

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

Descon, Digital Domain,

4 31391

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18755

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

eFunds,

5 17245

What is a trigger?

7 9117

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 16043

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

1 6432

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

2 10971

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

3 13168

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

5 40504

Un-Answered Questions { Databases }

What are the types of queries?

955

Explain different forms of normalization?

958

What are the types of dml?

997

What are transactions in sql?

1079

What do you mean by cluster and non cluster index?

1091

Is id a reserved word in sql?

1160

List out some features of neo4j database?

How do I start sql server?

992

How to view the error log for any specific instance? : sql server database administration

1053

How do you sort in sql?

1034

How do I manually uninstall oracle client?

1101

What are sql data types?

1037

What is pdo in mysql?

947

Does creating a foreign key create an index?

844

What are the different ddl commands in sql?

1184

For More Un-Answered { Databases } Questions Click Here