IBM
C2090-619 · Question #13
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?
The correct answer is B. Use the RETAIN UPDATE LOCKS clause with isolation level. See the full explanation below for the reasoning.
Question
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?
Options
- AUse the 'Committed Read' isolation level.
- BUse the RETAIN UPDATE LOCKS clause with isolation level.
- CUse the 'Cursor Stability' isolation level along the WITH HOLD clause.
- DUse the SET TRANSACTION command to with SERIALIZABLE clause.
How the community answered
(23 responses)- B83% (19)
- C4% (1)
- D13% (3)
Community Discussion
No community discussion yet for this question.