DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 26445

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

2 9781

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

3 6735

What is a join and explain different types of joins?

2 4713

Can you have a nested transaction?

1 2547

What is an extended stored procedure?

1 4719

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

1 3495

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

4 6221

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

Ramco,

2 7312

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?

2018

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

TCS,

16 56976

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

9 11879

What is normalization? Explain different levels of normalization?

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

8 60046

What is denormalization and when would you go for it?

NBP,

9 36617

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

Flextronics, Hexaware, SQL Star,

1 9235


Post New DB Development Questions

Un-Answered Questions { DB Development }

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

2451


Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2041


What is dbms and its application?

582


What is a database development?

553


Why does this query return 0?

649






What are the key features of dbms?

608


How long can an error message be in raiseerror function?

579


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

604


What is dbms explain in brief?

595


explain detail about ftp in datastage?

1848


In which table collections errors are stored.

1968


What is DB Development software?

1641


Explain the cube operator?

633


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

2102


How to generate OIDS

1685