SQL Server Locks Question:
Download Job Interview Questions and Answers PDF
What is Pessimistic concurrency?
Answer:
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.
Download MS SQL Server Locks Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is Optimistic concurrency? | Do you know the isolation level that SQL Server support? |