What are cursors? Explain different types of cursors?

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

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

What is a join and explain different types of joins?

Can you have a nested transaction?

What is an extended stored procedure?

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

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

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

Ramco,

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?

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

TCS,

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

What is normalization? Explain different levels of normalization?

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

What is denormalization and when would you go for it?

NBP,

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

Flextronics, Hexaware, SQL Star,