Explain optimistic and pessimistic concurrency?
Submitted by: AdministratorOptimistic concurrency: - Assumes that a resource is likely to be available at all times. This means that resource locking is very unlikely. If a conflict occurs, the application must read the data and attempt the change again.
Pessimistic concurrency : - this locks the resources as and when required. A transaction can be assured to be completed unless a deadlock occurs
Submitted by: Administrator
Pessimistic concurrency : - this locks the resources as and when required. A transaction can be assured to be completed unless a deadlock occurs
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. |