Which guildelines 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 to variable in a program
C. Use the %NOTFOUND attribute in combination with the SELECT INTO statement to check for non existent values
D. When using data manipulation language statements reference a SQL cursor attribute immediately after the DML statement executes in the same block
|
Download Printable PDF. VALID exam to help you PASS. |
 |