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 Overloading of procedures ?

Amdocs,

4 11310

How to return more than one value from a function?

Satyam,

11 31212

How can you create Cursor with parametres ?

3 8688

How you will create Toad Function?

1 17344

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Credit Suisse, GCU, Symphony, TCS,

4 27297

What's the difference between a primary key and a unique key?

4 8625

What are user defined datatypes and when you should go for them?

1 8164

What is bit datatype and what's the information that can be stored inside a bit column?

1 4821

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 116116

What are defaults? Is there a column to which a default can't be bound?

TCS,

2 9013

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 78181

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 8840

Explain Active/Active and Active/Passive cluster configurations

2 15909

What is RAID and what are different types of RAID configurations?

Wipro,

8 30633

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

Microsoft,

7 48044

Un-Answered Questions { Databases }

What is dao recordset in access?

935

What are different types of subquery?

1262

What is a join in the sql?

1006

What is native sql query?

1041

what is 'mysqlshow'? : Sql dba

1045

Does varchar need length?

1008

How do I connect to an rds postgres database?

913

Explain can SSRS reports Cache results?

161

How would you use transactions with couchdb?

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1097

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

679

What to do if dba lost the system password?

1190

How do I find query history in sql server?

956

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

907

Explain the terms specialization and generalization.

962

For More Un-Answered { Databases } Questions Click Here