DB Development Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Development Interview Questions

Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 28552

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

2 10815

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

3 7999

What is a join and explain different types of joins?

2 5639

Can you have a nested transaction?

1 3406

What is an extended stored procedure?

1 5582

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

1 4267

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

4 7807

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

Ramco,

2 8392

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?

2364

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

TCS,

16 60575

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

9 14245

What is normalization? Explain different levels of normalization?

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

8 62731

What is denormalization and when would you go for it?

NBP,

9 39021

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

Flextronics, Hexaware, SQL Star,

1 9873

Post New DB Development Questions

Un-Answered Questions { DB Development }

How long can an error message be in raiseerror function?

947

Explain the role of indexing in databases?

1075

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

951

What are the main phases of database development?

923

How can you fix a poorly performing query?

1107

I have a few records all are same structures data, I want to store data in multiple targets how

2594

How to use online Backups?

2156

Write the fastest query to find out how many rows exist in a table?

1062

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

3957

Explain about post-relational databases?

955

How you can make a parameterized view?

961

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

951

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?

2374

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

2163

Who are end users in dbms?

919

For More Un-Answered { DB Development } Questions Click Here