DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 26230

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

2 9682

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

3 6612

What is a join and explain different types of joins?

2 4616

Can you have a nested transaction?

1 2478

What is an extended stored procedure?

1 4621

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

1 3412

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

4 6012

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

Ramco,

2 7231

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?

1980

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

TCS,

16 56552

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

9 11600

What is normalization? Explain different levels of normalization?

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

8 59769

What is denormalization and when would you go for it?

NBP,

9 36384

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

Flextronics, Hexaware, SQL Star,

1 9155


Post New DB Development Questions

Un-Answered Questions { DB Development }

Explain about xml databases?

617


How to customize error conditions.

1696


What are the three types of database design?

537


Write short notes on manual refreshes.

2277


Why does this query return 0?

614






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

1651


explain detail about ftp in datastage?

1803


Explain about a primary key?

564


State the acid rules?

672


How to replace not in with not exist?

1454


Explain about the storage and physical database design?

521


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1776


Explain about post-relational databases?

575


Explain about relational operator join?

604


Explain the rollup operator?

600