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.
C.
D is invalid because:
docs.oracle.com/database/121/LNPLS/composites.htm#LNPLS99963
EXTEND is a procedure that adds elements to the end of a varray or nested table. The collection can be empty, but not null. (To make a collection empty or add elements to a null collection, use a constructor. For more information, see “Collection Constructors”.)
The EXTEND method has these forms:
EXTEND appends one null element to the collection.
EXTEND(n) appends n null elements to the collection.
EXTEND(n,i) appends n copies of the ith element to the collection.
C