DB Development Interview Questions
Questions Answers Views Company eMail

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

774

In which database can extended stored procedures be added?

720

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?

744

How you can make a parameterized view?

794

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

853

How long can an error message be in raiseerror function?

772

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

914

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

814

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?

775

Explain the cube operator?

809

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

803

What are the constraints on severity level in raiseerror?

779

Why does this query return 0?

823

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

818

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

830


Post New DB Development Questions

Un-Answered Questions { DB Development }

Explain about xml databases?

860


Explain about relational database management systems?

769


Explain about query and reporting.

1879


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

1902


Write short notes on manual refreshes.

2518


What is DB Development software?

1834


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

842


Explain about a primary key?

781


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

2032


How long can an error message be in raiseerror function?

772


How to use timestamp datatypes

1801


Explain about the relational database?

839


Explain about the hierarchical model of the database?

829


What are the key features of dbms?

789


Who are end users in dbms?

754