DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 23625

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

2 8455

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

3 4916

What is a join and explain different types of joins?

2 3474

Can you have a nested transaction?

1 1596

What is an extended stored procedure?

1 3467

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

1 2446

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

3 3880

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

Ramco,

2 6039

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?

1469

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

TCS,

16 51091

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

9 8816

What is normalization? Explain different levels of normalization?

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

8 55891

What is denormalization and when would you go for it?

NBP,

9 32672

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

SQL Star, Flextronics, Hexaware,

1 7962


Post New DB Development Questions






Un-Answered Questions { DB Development }

Explain the rollup operator?

78


Explain about the relational database?

78


What are the key features of dbms?

45


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

1716


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

83






What is the maximum length of an extended property?

79


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?

90


Explain about the database management systems.

76


Explain about a primary key?

80


How can I detect whether a given connection is blocked?

81


Explain about xml databases?

75


How would you design a database for an online site, which would average a million hits a day?

85


What is an application role and explain a scenario when you would use one?

76


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

2674


What is dbms and its application?

44