Identify the scenario in which you would use the current of clause for an update or delete
statement to rows fetched from a cursor.
A.
when you want to lock the rows fetched by the cursor
B.
when you want to update or delete the result set without affecting the rows in the table ‘
C.
when you want the database not to wait if the requested rows are locked by another user
D.
when you want to ensure that the current rows fetched by the cursor are updated or deleted
Explanation:
d
http://www.techonthenet.com/oracle/cursors/current_of.php
The answer is D because
1) It is not A and not C because “current of” statement is applicable only for cursor opened in “for update” mode (it means rows are allready locked when cursor is opened)
2) It is not B because “update or delete the result set without affecting the rows in the table” does not make any sence at all…
D
D
D
D
D
d