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.
please refer Answer of this Question No.70
A, C?
record is preferable over individual variable, FOR LOOP is preferable over OPEN,FETCH,CLOSE
A,D
But guideline is just recommendation (But sometimes very useful :))