Question 10
Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.
Select an option, then click Submit answer.
-
○
when you want to lock the rows fetched by the cursor
-
○
when you want to update or delete the result set without affecting the rows in the table
-
○
when you want the database not to wait if the requested rows are locked by another user
-
○
when you want to ensure that the current rows fetched by the cursor are updated or deleted
