Scenario: You are working on an application where multiple users can update the same database record simultaneously. Which concurrency model would you recommend to handle potential conflicts in this scenario?

  • Dirty Read Concurrency
  • Optimistic Concurrency
  • Pessimistic Concurrency
  • Snapshot Concurrency
Optimistic concurrency is the preferred model for handling potential conflicts when multiple users can update the same record simultaneously. It assumes that conflicts are rare, allowing multiple users to access and modify the data concurrently. When a user attempts to commit changes, the system checks whether the data has been modified since it was last retrieved. If no modifications are detected, the changes are applied successfully.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *