Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.

Identify the scenario in which you would use the current of clause for an update or delete
statement to rows fetched from a cursor.

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:



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Leonid

Leonid

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…

samkelo siyabonga ngubo

samkelo siyabonga ngubo

D