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 happens if date-only values are provided as date and time literals?

0 Answers  


What is Index Segmentation ?

1 Answers   TCS,


What are the different types of collation sensitivity?

0 Answers  


Can you index views?

0 Answers  


What are partitioned views and distributed partitioned views?

0 Answers  






What is the Control Flow in SSIS

0 Answers   HCL,


Does server sql treat char as a variable-length or fixed-length column?

0 Answers  


Can sql server 2016 run on windows 7?

0 Answers  


How to handle error or exception in sql?

0 Answers  


How to download and install sql server 2005 books online?

0 Answers  


One table how may column and Primary key

3 Answers  


can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,


Categories