SQL Server Locks Question:

What is Optimistic concurrency?

Tweet Share WhatsApp

Answer:

Optimistic concurrency: It assumes that resource conflicts between multiple users are very unlikely to occur and thus allows transactions to execute without any locking mechanisms on the resources. It is only while changing the data that a check is made on resources if any conflicts have occurred. If there’s a conflict then the application must read the data again and try to change it as well.

Download MS SQL Server Locks PDF Read All 16 MS SQL Server Locks Questions
Previous QuestionNext Question
Explain what is lock escalation and what is its purpose?What is Pessimistic concurrency?