What’s difference between “optimistic” and “pessimistic” locking?



What’s difference between “optimistic” and “pessimistic” locking?..

Answer / Tejaswi Anand

Optimistic locking assumes that conflicts will be rare, and checks for conflicts only when the data is saved. If a conflict occurs, the save operation fails. Pessimistic locking, on the other hand, locks the data at the time of retrieval to prevent conflicts during editing, ensuring consistency but potentially limiting concurrency.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

How to make paging concepts in datagrid in ASP.NET?

1 Answers   Sans Pareil IT Services,


Explain how do you deploy your asp.net application?

1 Answers  


Whats the use of @ Register directives ?

4 Answers  


In which event of page cycle is the viewstate available?

1 Answers  


What tags do you need to add within the asp:datagrid tags to bind columns manually

2 Answers  


What is the use of directives & explain with example?

2 Answers   C Squared Systems,


What are session variables?

2 Answers   Microsoft,


What is an assembly?

2 Answers   Value Labs,


Why should i prefer JSP over asp.net or any other web development language..??

1 Answers  


List down the sequence of methods called during the page load.

1 Answers  


what are debugging types in .net?

2 Answers   ABC, NIIT,


How many webforms are possible on a single webpage?

6 Answers  


Categories