DB Development Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Development Interview Questions

Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 28857

What are the disadvantages of cursors? How can you avoid cursors?

2 10964

Explain the general syntax for a SELECT statements covering all the options.

3 8167

What is a join and explain different types of joins?

2 5767

Can you have a nested transaction?

1 3516

What is an extended stored procedure?

1 5702

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

1 4369

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

4 8073

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

Ramco,

2 8520

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?

2423

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

TCS,

16 61237

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

9 14544

What is normalization? Explain different levels of normalization?

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

8 63125

What is denormalization and when would you go for it?

NBP,

9 39395

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

Flextronics, Hexaware, SQL Star,

1 9985

Post New DB Development Questions

Un-Answered Questions { DB Development }

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1003

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

970

How to generate OIDS

2261

What are the key features of dbms?

996

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

968

What are the three types of database design?

1025

Explain about post-relational databases?

1027

What are the types of database model?

1097

Explain about the hierarchical model of the database?

1118

How to customize error conditions.

2152

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1068

What are data modelling techniques?

972

Which four data types cannot be used as a return type from a user-defined function?

1028

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4012

How to use timestamp datatypes

2042

For More Un-Answered { DB Development } Questions Click Here