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 28785

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

2 10935

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

3 8135

What is a join and explain different types of joins?

2 5740

Can you have a nested transaction?

1 3498

What is an extended stored procedure?

1 5678

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

1 4345

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

4 8018

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

Ramco,

2 8493

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?

2411

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

TCS,

16 61088

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

9 14496

What is normalization? Explain different levels of normalization?

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

8 63044

What is denormalization and when would you go for it?

NBP,

9 39307

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

Flextronics, Hexaware, SQL Star,

1 9959

Post New DB Development Questions

Un-Answered Questions { DB Development }

State the acid rules?

1120

How to combine two function together?

2120

How you can make a parameterized view?

1001

What are the constraints on severity level in raiseerror?

980

What are the types of database model?

1077

Explain about the relational database?

1058

In which table collections errors are stored.

2401

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?

953

How to use online Backups?

2196

How to generate OIDS

2241

Explain about normal forms?

1045

What are the three basic rules which are to be followed for the relational model of the database?

1008

How can I detect whether a given connection is blocked?

1040

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2844

Explain about relational operator join?

1029

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