DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 27328

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

2 10160

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

3 7270

What is a join and explain different types of joins?

2 5084

Can you have a nested transaction?

1 2853

What is an extended stored procedure?

1 5047

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

1 3806

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

4 6897

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

Ramco,

2 7707

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?

2183

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

TCS,

16 58414

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

9 12849

What is normalization? Explain different levels of normalization?

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

8 61186

What is denormalization and when would you go for it?

NBP,

9 37533

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

Flextronics, Hexaware, SQL Star,

1 9533


Post New DB Development Questions

Un-Answered Questions { DB Development }

What are the three types of database design?

748


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?

713


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1995


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

2611


Explain about relational operator join?

797


Explain about the relational database?

807


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

778


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

1866


How to use timestamp datatypes

1772


Explain about the database management systems.

741


How can you log an error to the server event log from a stored procedure?

794


What is DB Development software?

1803


Explain about post-relational databases?

755


Explain about query and reporting.

1855


Explain the rollup operator?

823