DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 26242

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

2 9685

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

3 6616

What is a join and explain different types of joins?

2 4617

Can you have a nested transaction?

1 2478

What is an extended stored procedure?

1 4628

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

1 3412

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

4 6014

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

Ramco,

2 7232

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?

1982

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

TCS,

16 56556

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

9 11620

What is normalization? Explain different levels of normalization?

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

8 59775

What is denormalization and when would you go for it?

NBP,

9 36394

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

Flextronics, Hexaware, SQL Star,

1 9159


Post New DB Development Questions

Un-Answered Questions { DB Development }

Explain about network model?

580


What is dbms and its application?

546


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

1668


In which table collections errors are stored.

1931


What are the three types of database design?

537






Can an extended stored procedure be called from inside a user-defined function?

605


Where is dbms used?

619


How long can an error message be in raiseerror function?

540


Write short notes on manual refreshes.

2279


fact table and dimension table containg one to many relationship or many to one relastionship

2071


Explain about normal forms?

593


How can you fix a poorly performing query?

616


Explain about the storage and physical database design?

524


How to customize error conditions.

1699


What is the maximum length of an extended property?

548