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 6367

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 8310

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

3 14547

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 31535

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 18963

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

eFunds,

5 17387

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 16150

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

1 6496

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

2 11045

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

3 13284

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

5 40642

Un-Answered Questions { Databases }

What is database black box testing?

1078

How did mongodb get its name?

What are the types of Generic profiles types in ODI?

782

How to convert binary strings into integers in ms sql server?

1085

What is the stored procedure to view current lock and processes respectively?

950

What is default value database?

1069

How can I create database in oracle?

1069

Which language is best for mongodb?

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1162

How do I create a collection in mongodb? Write it's syntax

What is difference between sql and sql server?

1081

what is memory-optimized nonclustered indexes

1067

Explain what is lock escalation?

1113

What is a procedure in pl sql?

1292

Can you skip header records while loading? : aql loader

1102

For More Un-Answered { Databases } Questions Click Here