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?

962

In which database can extended stored procedures be added?

893

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?

953

How you can make a parameterized view?

1001

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

1045

How long can an error message be in raiseerror function?

991

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

1105

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

1002

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?

995

Explain the cube operator?

995

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

1001

What are the constraints on severity level in raiseerror?

980

Why does this query return 0?

1007

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

1011

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

1093

Post New DB Development Questions

Un-Answered Questions { DB Development }

In which database can extended stored procedures be added?

893

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

1065

How to use online Backups?

2196

Explain about the relational database?

1059

Explain about the hierarchical model of the database?

1106

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?

961

What is database design and development?

1007

What are the three types of database design?

1019

Explain the process of the user request and data generating?

1088

How can you fix a poorly performing query?

1172

What is dbms and its application?

996

Explain about xml databases?

1052

Explain the role of indexing in databases?

1120

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

2134

What is the maximum length of an extended property?

979

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