DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 26314

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

2 9721

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

3 6655

What is a join and explain different types of joins?

2 4665

Can you have a nested transaction?

1 2510

What is an extended stored procedure?

1 4664

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

1 3439

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

4 6096

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

Ramco,

2 7259

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?

1998

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

TCS,

16 56720

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

9 11707

What is normalization? Explain different levels of normalization?

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

8 59865

What is denormalization and when would you go for it?

NBP,

9 36468

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

Flextronics, Hexaware, SQL Star,

1 9187


Post New DB Development Questions

Un-Answered Questions { DB Development }

How to customize error conditions.

1706


How can I detect whether a given connection is blocked?

589


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

3447


What is the database development process?

696


Explain about post-relational databases?

587






Explain about the database management systems.

572


How to read and create .LDC data files which are used by linguatic dictionary.

2066


Explain about the hierarchical model of the database?

588


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

568


What is database design and development?

613


How long can an error message be in raiseerror function?

554


Which data type cannot be used as a parameter in a udf?

580


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

2425


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?

1998


Explain what a database is?

619