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

DB Development Interview Questions

Questions Answers Views Company eMail

Which data type cannot be used as a parameter in a udf?

1024

In which database can extended stored procedures be added?

954

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?

1020

How you can make a parameterized view?

1071

Can an extended stored procedure be called from inside a user-defined function?

1117

How long can an error message be in raiseerror function?

1047

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

1174

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

1077

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1056

Explain the cube operator?

1060

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

1056

What are the constraints on severity level in raiseerror?

1052

Why does this query return 0?

1056

Which four data types cannot be used as a return type from a user-defined function?

1063

How can you log an error to the server event log from a stored procedure?

1175

Post New DB Development Questions

Un-Answered Questions { DB Development }

Explain about the relational database?

1132

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

1063

Explain the rollup operator?

1143

How to customize error conditions.

2200

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

2190

State the acid rules?

1184

How to combine two function together?

2204

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?

1051

What are the types of database model?

1140

Explain the role of indexing in databases?

1191

How can I detect whether a given connection is blocked?

1120

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 is the database development process?

1272

How can you log an error to the server event log from a stored procedure?

1175

Explain about normal forms?

1108

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