SQL Server Locks Interview Question:

What is Pessimistic concurrency?

Submitted by: Administrator

Pessimistic concurrency: Assumes that resource conflicts between multiple users are very likely to occur and hence locks resources as they are used by transactions for the duration of the transaction. A transaction is assured of successful completion unless a Deadlock ocurrs.
Submitted by: Administrator