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 an extended stored procedure?

1 5721

Can you instantiate a COM object by using T-SQL?

1 4380

What is the system function to get the current user's user id?

4 8100

What are triggers? How many triggers you can have on a table?

Ramco,

2 8537

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2435

What is a self join? Explain it with an example?

TCS,

16 61326

Given an employee table, how would you find out the second highest salary?

9 14603

What is normalization? Explain different levels of normalization?

CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

8 63181

What is denormalization and when would you go for it?

NBP,

9 39447

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

Flextronics, Hexaware, SQL Star,

1 10000

Define candidate key, alternate key, composite key?

IAS, IBM,

30 145840

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

2 7658

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

2 8477

Can you create a updatecascade, Deletecascade relation in Ms-Access? If yes, give an example?

2 9220

What is a 'instead of trigger'?

Eenadu, TCS,

3 12987

Un-Answered Questions { Databases }

What do you mean by DBMS?

985

Why we use bulk collect in oracle?

1064

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

595

How do I know if mongodb is installed?

What is microsoft access best used for?

932

What is proper subset of candidate key?

1013

What is the mandatory setup in cyclecount ?

2770

Why do we use bulk collect in oracle?

1075

How do I find my localdb version?

999

how do u compile a form i.e .fmb file in Unix or in dos

4581

How many primary keys are possible in a table?

935

What are unicode character string data types in ms sql server?

1273

What is recompile sql server?

1055

How do I limit the number of oracle database connections generated by weblogic server?

1086

Can you rename a database in mysql?

1043

For More Un-Answered { Databases } Questions Click Here