In order to test your progress, you should be able to answer the following questions.
Multilevel collections are not supported by Oracle 8i.
A varray of varrays has an upper bound
_____ that is fixed and cannot be extended to all.
_____ that can be extended to its maximum size.
_____ that can be extended without any limits.
There is no need to initialize a nested table of index-by tables prior to its use.
Consider the following script for the next two questions:
DECLARE TYPE varray_type1 IS VARRAY(3) OF INTEGER; TYPE varray_type2 IS VARRAY(10) OF varray_type1; varray1 varray_type1 := varray_type1(1, 2, 3); varray2 varray_type2 := varray_type2(varray1, varray_type1(4, 5, 6)); var1 INTEGER; BEGIN var1 := varray2(2)(3); varray2.EXTEND; varray2(3) := varray_type1(0); varray2(3).EXTEND; END;
Based on the preceding script, what is the value of the variable VAR1?
_____ There is no value because the script generates an error.
The statement varray2(3).EXTEND
_____ adds a third element to the third element of VARRAY2.
_____ adds a second element to the third element of VARRAY2.
_____ causes a 'Subscript beyond count' error.
Answers appear in Appendix A, Section 18.3 .