View the Exhibit and examine the code in the PL/SQL block.

The PL/SQL block generates an error on execution. What is the reason?

• A. The DELETE(n) method cannot be used with nested tables.
• B. The DELETE(n) method cannot be used with varrays.
• C. The NEXT method cannot be used with an associative array with VARCHAR2 key values.
• D. The NEXT method cannot be used with a nested table from which an element has been deleted.

Which two statements are true about cursor variables? (Choose two.)

• A. A cursor variable points to the current row in the result set of a multirow query stored in a work area.
• B. A cursor variable is an explicitly named work area in which the results of different multirow queries can be stored.
• C. A cursor variable can be used only if a query is performed and its results are processed in the same subprogram.
• D. A cursor variable can be used to perform a query in one subprogram, and process the results in a different subprogram.

Which two statements are true about cursor variables? (Choose two.)

• A. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
• B. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.
• C. The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
• D. The FETCH statement executes the query associated with a cursor variable and identifies the result set.
• E. Cursor variables can be parameterized like cursors.

Which two statements are true about the tuning of PL/SQL code? (Choose two.)

• A. Redundant SQL statements in PL/SQL code should be avoided.
• B. Usage of the NOT NULL constraint in PL/SQL code can degrade performance.
• C. If you have one PL/SQL program unit instead of multiple smaller executable sections, performance can be improved.
• D. Implicit data type conversion in PL/SQL code can improve performance.