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
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Providing quote from the references: http://oraclexpert.com/basic-oracle-dba/sql/for-update-clause-in-a-select-statement/
http://sql-plsql.blogspot.com/2007/05/oracle-plsql-where-current-of-for.html
“The WHERE CURRENT OF clause in an UPDATE or DELETE statement states that the most recent row fetched from the table should be updated or deleted. We must declare the cursor with the FOR UPDATEclause to use this feature.”
NOT A: Row lock is not purpose, but side effect of using cursor for update.