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 28834

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

2 10958

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

3 8157

What is a join and explain different types of joins?

2 5763

Can you have a nested transaction?

1 3510

What is an extended stored procedure?

1 5699

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

1 4360

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

4 8056

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

Ramco,

2 8515

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?

2419

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

TCS,

16 61200

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

9 14533

What is normalization? Explain different levels of normalization?

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

8 63104

What is denormalization and when would you go for it?

NBP,

9 39365

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

Flextronics, Hexaware, SQL Star,

1 9981

Post New DB Development Questions

Un-Answered Questions { DB Development }

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?

961

How long can an error message be in raiseerror function?

1000

Write short notes on manual refreshes.

2732

How can you fix a poorly performing query?

1180

State the acid rules?

1128

Explain about query and reporting.

2088

What is dbms and its application?

1001

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

1013

What are the key features of dbms?

992

How to use online Backups?

2198

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

1010

Explain about normal forms?

1054

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

2855

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2142

How to use timestamp datatypes

2035

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