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 5710

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

1 4372

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

4 8084

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

Ramco,

2 8525

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?

2428

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

TCS,

16 61284

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

9 14565

What is normalization? Explain different levels of normalization?

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

8 63147

What is denormalization and when would you go for it?

NBP,

9 39415

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

Flextronics, Hexaware, SQL Star,

1 9992

Define candidate key, alternate key, composite key?

IAS, IBM,

30 145727

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

2 7642

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

2 8470

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

2 9207

What is a 'instead of trigger'?

Eenadu, TCS,

3 12974

Un-Answered Questions { Databases }

What is the role of use command?

Does truncate release storage space?

1087

What is package in dbms?

888

How to schedule ssas database backup

1001

What are the properties of a transaction?

1130

Why do we use procedures in pl sql?

1051

Is sql sequential or random?

1042

Does adding an index lock a table?

965

What are different between mongodb and sql server databases?

How do you delete a column?

846

What is merge replication?

1113

What is pivot table in sql?

1115

Which is best pdo or mysqli?

924

Explain the terms database and dbms?

928

Is mysql server free?

936

For More Un-Answered { Databases } Questions Click Here