IBM
C2090-320 · Question #26
Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the…
The correct answer is D. ISOLATION(CS) CURRENTDATA(YES). See the full explanation below for the reasoning.
Question
Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?
Options
- AISOLATION(UR)
- BISOLATION(RS)
- CISOLATION(CS) CURRENTDATA(NO)
- DISOLATION(CS) CURRENTDATA(YES)
How the community answered
(55 responses)- A5% (3)
- B4% (2)
- C11% (6)
- D80% (44)
Community Discussion
No community discussion yet for this question.