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?

974

In which database can extended stored procedures be added?

902

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?

962

How you can make a parameterized view?

1011

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

1053

How long can an error message be in raiseerror function?

1000

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

1116

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

1013

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?

1000

Explain the cube operator?

1006

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

1010

What are the constraints on severity level in raiseerror?

985

Why does this query return 0?

1014

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

1023

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

1105

Post New DB Development Questions

Un-Answered Questions { DB Development }

Explain what a database is?

1044

What is dbms explain in brief?

1029

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

1014

Explain the rollup operator?

1075

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).

2211

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2055

How to use online Backups?

2199

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

1105

How long can an error message be in raiseerror function?

1000

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 is database design and development?

1016

In which table collections errors are stored.

2409

Explain about the database management systems.

968

How to generate OIDS

2253

How can you fix a poorly performing query?

1181

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