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?

914

In which database can extended stored procedures be added?

859

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?

904

How you can make a parameterized view?

961

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

1009

How long can an error message be in raiseerror function?

947

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

1062

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

959

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?

957

Explain the cube operator?

940

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

951

What are the constraints on severity level in raiseerror?

938

Why does this query return 0?

971

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

969

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

1040

Post New DB Development Questions

Un-Answered Questions { DB Development }

How can you fix a poorly performing query?

1107

Explain about normal forms?

1000

Explain the cube operator?

940

What are the constraints on severity level in raiseerror?

938

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2364

explain detail about ftp in datastage?

2190

Who are naive users?

956

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?

2374

How to read and create .LDC data files which are used by linguatic dictionary.

2479

What is dbms and its application?

948

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

1009

What are the key features of dbms?

947

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

1019

What is data modeling with example?

913

Explain what a database is?

985

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