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

What is the temp table?

940

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1221

List some advantages and disadvantages of stored procedure?

1029

What factors you will consider calculating the storage requirement for that view?

965

List out different types of normalizations in sql server and explain each of them?

948

What are the different authentication modes in sql server? How can it be changed?

1105

What are the different types of locks in the database?

943

Why use “pivot” in sql server?

1146

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1418

What is built-in/administrator?

1035

What is the difference between a unique key and primary key?

971

What the different topologies in which replication can be configured?

1113

What is index, cluster index and nonclustered index?

1013

What is a recursive stored procedure in sql server?

1195

What is acid mean in sql server?

1148

Un-Answered Questions { Databases }

What is indexing in database with example?

989

Which one is better sql or oracle?

994

What are inner outer left and right joins in sql?

1028

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1831

How to compare dates in oracle sql?

1125

What is the difference between cartesian product and cross join?

876

Can you lock more than one database at the same time in mongodb?

What is Data Redundancy and Consistency ?

1021

in mongodb, What is crud?

Create an append query?

804

which table keeps the locking information? : Sql server administration

1113

how to use regular expression in pattern match conditions? : Sql dba

1064

Why do we use subquery?

1036

What is an Extension of entity type?

868

What is the function of myisamchk?

986

For More Un-Answered { Databases } Questions Click Here