Oracle
1Z0-144 · Question #17
Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.
The correct answer is D. FOR UPDATE + CURRENT OF. "when you want to ensure" it is about exclusive rows lock in FOR UPDATE "current rows fetched by cursor" it is about CURRENT OF in FOR UPDATE clause
Configuring JDBC Data Sources
Question
Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.
Options
- Ait is about locks, not about current of clause
- BNONSENCE, RAVE, we can't delete/update rows from table without affecting row in the table
- CFor Update NOWAIT clause
- DFOR UPDATE + CURRENT OF
How the community answered
(57 responses)- A11% (6)
- B2% (1)
- C5% (3)
- D82% (47)
Explanation
"when you want to ensure" it is about exclusive rows lock in FOR UPDATE "current rows fetched by cursor" it is about CURRENT OF in FOR UPDATE clause
Topics
#cursor FOR UPDATE#CURRENT OF clause#row locking#cursor operations
Community Discussion
No community discussion yet for this question.