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 11523

How to return more than one value from a function?

Satyam,

11 31712

How can you create Cursor with parametres ?

3 8867

How you will create Toad Function?

1 17414

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

Credit Suisse, GCU, Symphony, TCS,

4 27468

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

4 8815

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

1 8239

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

1 4912

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 116714

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

TCS,

2 9158

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 78786

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

3 8977

Explain Active/Active and Active/Passive cluster configurations

2 16036

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

Wipro,

8 31048

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

Microsoft,

7 48294

Un-Answered Questions { Databases }

Is primary key clustered index?

1015

What are the advantages of database?

1009

what is the command syntax for inserting a document?

Why and when do stored procedure recompile?

1052

How to use values from other tables in update statements using oracle?

1149

What is standby servers? Explain types of standby servers.

1072

Explain system functions or built-in functions? What are different types of system functions?

1060

What versions of clipper does netlib support?

1086

What is an indexed view?

1018

Where can you add custom error messages to sql server?

1203

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1292

How to Change a users password from unix shell.

1212

How can you append an identity column to a temporary table?

1065

Why use identity in sql server?

1191

What is self contained sub query?

1138

For More Un-Answered { Databases } Questions Click Here