Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB Development Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 24012

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

2 8605

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

3 5075

What is a join and explain different types of joins?

2 3607

Can you have a nested transaction?

1 1695

What is an extended stored procedure?

1 3604

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

1 2563

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

3 4046

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

Ramco,

2 6186

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?

1569

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

TCS,

16 51862

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

9 9134

What is normalization? Explain different levels of normalization?

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

8 56471

What is denormalization and when would you go for it?

NBP,

9 33246

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

Flextronics, Hexaware, SQL Star,

1 8087


Post New DB Development Questions






Un-Answered Questions { DB Development }

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

1216


What are the three basic rules which are to be followed for the relational model of the database?

136


What are the types of database model?

107


Explain what a database is?

156


Explain the role of indexing in databases?

130






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?

148


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

137


Explain about query and reporting.

1279


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

1574


What is dbms explain in brief?

107


What are data modelling techniques?

103


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

138


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

2760


How to use online Backups?

1242


State the acid rules?

139