Which guidelines should be considered when designing and using cursors in a PL/SQL block? ?
(Choose all that apply.)
A.
 When fetching from a cursor, fetch into a record.
B.
 Use parameters with cursors so that the result set for the cursor is not tied to a specific 
variable in a program. 
 
C.
 Use the %NOTFOUND attribute in combination with the SELECT INTO statement to check for 
non existent values.
D.
 Whenever possible, explicitly declare the cursor and use the OPEN, FETCH and CLOSE 
statements to manipulate the cursor instead of using cursor FOR loop.
E.
 When using data manipulation language statements, (DML) reference a SQL cursor attribute 
immediately after the DML statement executes in the same block.
A, B, E
ABD