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 29100

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

2 11074

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

3 8297

What is a join and explain different types of joins?

2 5879

Can you have a nested transaction?

1 3610

What is an extended stored procedure?

1 5802

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

1 4454

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

4 8274

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

Ramco,

2 8630

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?

2470

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

TCS,

16 61724

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

9 14842

What is normalization? Explain different levels of normalization?

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

8 63433

What is denormalization and when would you go for it?

NBP,

9 39749

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

Flextronics, Hexaware, SQL Star,

1 10054

Post New DB Development Questions

Un-Answered Questions { DB Development }

Explain the role of indexing in databases?

1191

Explain the rollup operator?

1143

Explain about the storage and physical database design?

971

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

1077

What is the physical representation for a many-to-many relationship?

1141

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?

2473

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

2906

What are the three types of database design?

1085

How to combine two function together?

2204

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

1056

How to use online Backups?

2262

What is database design and development?

1063

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?

1025

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2084

Explain about normal forms?

1108

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