Data Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

What information is maintained within the msdb database?

1023

Which database stores information about replication?

1132

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

1027

In which database can extended stored procedures be added?

954

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

1082

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?

1060

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

1058

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

1065

How do I keep secret data in my playbook?

What are advantages of microsoft-provided data provider classes in ado.net?

1040

What are disadvantages of microsoft-provided data provider classes in ado.net?

1101

Mention the namespace that is used to include .net data provider for sql server in .net code?

1008

Name the method that needs to be invoked on the dataadapter control to fill the generated dataset with data?

1046

Which adapter should you use, if you want to get the data from an access database?

1031

In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?

1275