IBM
C2090-619 · Question #13
C2090-619 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-619 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
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.
Unlock C2090-619 to see the answer
You've previewed enough free C2090-619 questions. Unlock C2090-619 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.