What are pessimistic lock and optimistic lock?


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

Post New Answer

More SQL Server Interview Questions

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


What is service broker?

0 Answers  


what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,


Can truncate be rolled back?

0 Answers  


What is the language structure to add a record to a table?

0 Answers  






Why is sql server log file full?

0 Answers  


What are cursors in ms sql server?

0 Answers  


Do you know sql server 2008 introduces automatic auditing?

0 Answers  


What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,


What are the types of subquery?

0 Answers  


sql server architecture ?

0 Answers  


What do you understand by recursive stored procedure?

0 Answers  


Categories