What is Optimistic concurrency?
Submitted by: AdministratorOptimistic 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.
Submitted by: Administrator
Submitted by: Administrator
Read Online SQL Server Locks Job Interview Questions And Answers
Top SQL Server Locks Questions
| ☺ | What is a live lock? |
| ☺ | Do you know what guidelines should be followed to help minimize deadlocks? |
| ☺ | What is a dead lock? |
| ☺ | Explain what is lock escalation and what is its purpose? |
| ☺ | Explain optimistic and pessimistic concurrency? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
