Which statement is true about the execution of the PL/SQL code?

View the Exhibit and examine the PL/SQL code.

Which statement is true about the execution of the PL/SQL code?

View the Exhibit and examine the PL/SQL code.

Which statement is true about the execution of the PL/SQL code?

A.
It executes successfully and displays 101 and 200000 values.

B.
The ASSIGN_VAL function generates an error during compilation because nested tables
cannot be returned by functions.

C.
The SELECT statement generates an error because the nested table has not been initialized
in the ASSIGN_VAL function.

D.
The ASSIGN_VAL function generates an error during compilation because the EXTEND
method cannot be used with nested tables.



Leave a Reply 1

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