DB Development Interview Questions
Questions Answers Views Company eMail

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

580

In which database can extended stored procedures be added?

536

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?

530

How you can make a parameterized view?

561

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

617

How long can an error message be in raiseerror function?

554

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

668

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

596

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?

573

Explain the cube operator?

607

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

585

What are the constraints on severity level in raiseerror?

590

Why does this query return 0?

626

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

585

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

564


Post New DB Development Questions

Un-Answered Questions { DB Development }

Explain about the hierarchical model of the database?

586


Explain about post-relational databases?

585


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

585


Why does this query return 0?

626


explain detail about ftp in datastage?

1819






What are the three types of database design?

549


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

582


Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2016


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1593


How to replace not in with not exist?

1470


How to use online Backups?

1734


What is database design and development?

609


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

596


What is the database development process?

692


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

580