MB6-704 · Question #69
You have a process that throws an UpdateConflict exception. You need to identify a possible cause of the exception. What should you identify?
The correct answer is D. The record changed between the time you selected the record for update and the time you attempted. Optimistic Concurrency Control (OCC) helps increase database performance. Pessimistic Con- currency Control locks records as soon as they are fetched from the database for an update. How- ever, Optimistic Concurrency only locks records from the time when the actual update is…
Question
You have a process that throws an UpdateConflict exception. You need to identify a possible cause of the exception. What should you identify?
Options
- AThe security for the table in which the record resides was changed between the time you selected
- Ba new record was inserted in the table between the time you selected the record for update and
- CThe table in which the record resides was renamed between the time you selected the record for
- DThe record changed between the time you selected the record for update and the time you attempted
How the community answered
(51 responses)- A4% (2)
- B6% (3)
- C14% (7)
- D76% (39)
Explanation
Optimistic Concurrency Control (OCC) helps increase database performance. Pessimistic Con- currency Control locks records as soon as they are fetched from the database for an update. How- ever, Optimistic Concurrency only locks records from the time when the actual update is OCC makes it possible for other processes to update a record even after it has been fetched. You can catch update conflicts by catching the UpdateConflict and UpdateConflictNotRecovered ex-
Topics
Community Discussion
No community discussion yet for this question.