1.what is the diff between nolock optimizer and read
uncommitted
isolation?
2.what is the diff between revoke and deny?
3.what is percieved down time?
4.whether password protection are required for backups?if
yes why?if no why?
5.what is fill factor?
6.what is cost analysis?
7.what is mean by piece meal restore?
8.what is 'rowguidcol'?
9.impersonate permission?
10.what is selectivity?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are indexes in sql?

0 Answers  


What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,


How can delete duplicate records in cte in sql server?

0 Answers  


How to loop through result set objects using mssql_fetch_array()?

0 Answers  


Is mysql the same as sql server?

0 Answers  






What do you understand by triggers and mention the different types of it?

0 Answers  


Do you know how to make remote connection in database?

0 Answers  


Define normalisation?

0 Answers  


What is model database in sql server?

0 Answers  


Why use sub query in sql server and list out types of sub queries?

0 Answers  


Is truncate a dml command?

0 Answers  


What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,


Categories