Lab 18.3 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

1)	Multilevel collections are not supported by Oracle 8i. _____ True _____ False
2)	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.
3)	There is no need to initialize a nested table of index-by tables prior to its use. _____ True _____ False 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;
4)	Based on the preceding script, what is the value of the variable VAR1? _____ There is no value because the script generates an error. _____ 2 _____ 6
5)	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 .