Which two guidelines should be considered when designing and using cursors in a PL/SQL block?

Which two guidelines should be considered when designing and using cursors in a PL/SQL block?
(Choose two.)

Which two guidelines should be considered when designing and using cursors in a PL/SQL block?
(Choose two.)

A.
When fetching from a cursor, fetch into a record.

B.
When fetching from a cursor, fetch required values into individually declared variables.

C.
Whenever possible, explicitly declare the cursor and use the OPEN, FETCH, and CLOSE statements to manipulate the cursor instead of using the cursor FOR loop.

D.
Whenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and using the OPEN, FETCH, and CLOSE statements to manipulate the cursor.



Leave a Reply 4

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


Rajnish

Rajnish

please refer Answer of this Question No.70

Leo Yu

Leo Yu

record is preferable over individual variable, FOR LOOP is preferable over OPEN,FETCH,CLOSE

duff

duff

A,D
But guideline is just recommendation (But sometimes very useful :))