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

What is Overloading of procedures ?

Amdocs,

4 11445

How to return more than one value from a function?

Satyam,

11 31511

How can you create Cursor with parametres ?

3 8801

How you will create Toad Function?

1 17399

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

Credit Suisse, GCU, Symphony, TCS,

4 27410

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

4 8762

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

1 8222

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

1 4889

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 116521

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

TCS,

2 9102

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 78566

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

3 8949

Explain Active/Active and Active/Passive cluster configurations

2 15983

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

Wipro,

8 30904

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

Microsoft,

7 48198

Un-Answered Questions { Databases }

How to count rows with the count(*) function in ms sql server?

1064

What is the significance of null value and why should we avoid permitting null values?

1037

What is keys and its types?

1123

What are the advantages and disadvantages of using mysql?

1054

20. Using a set operator, display the client number of all clients who have never placed an order.

2250

How can we find out which auto increment was assigned on Last insert?

1143

How do I create a postgresql table using pgadmin?

884

Explain the role of indexing in databases?

1191

What is the process of copying data from table a to table b?

1141

a text item is there what r the different types of triggers associated with it

2085

How do I run mysql from command line?

1108

Explain what are the events recorded in a transaction log?

1053

What is the data quality?

670

What is the difference between joins?

1094

What is index, cluster index and nonclustered index?

1052

For More Un-Answered { Databases } Questions Click Here