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

1 5817

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

1 4465

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

4 8316

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

Ramco,

2 8645

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?

1 2474

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

TCS,

16 61796

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

9 14899

What is normalization? Explain different levels of normalization?

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

9 63506

What is denormalization and when would you go for it?

NBP,

9 39807

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

Flextronics, Hexaware, SQL Star,

1 10065

Define candidate key, alternate key, composite key?

IAS, IBM,

30 146806

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

2 7818

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

2 8579

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

2 9320

What is a 'instead of trigger'?

Eenadu, TCS,

3 13116

Un-Answered Questions { Databases }

What is the difference between upgrade and migration in sql server?

1163

What is a view in sql?

1033

How can I check that whether automatic statistic update is enabled or not?

1101

What is the best sql course?

1031

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

How do I create a trace in sql server?

1102

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8210

define sql insert statement ? : Sql dba

1086

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

1277

Can delete statement be rollbacked?

1038

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

What is a scheduled job or what is a scheduled task?

1019

Can one drop a column from a table?

1075

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2035

Explain “row_number()” in sql server with an example?

1061

For More Un-Answered { Databases } Questions Click Here