Lab 18.3 Self-Review Questions

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


Multilevel collections are not supported by Oracle 8i.

  1. _____ True

  2. _____ False


A varray of varrays has an upper bound

  1. _____ that is fixed and cannot be extended to all.

  2. _____ that can be extended to its maximum size.

  3. _____ that can be extended without any limits.


There is no need to initialize a nested table of index-by tables prior to its use.

  1. _____ True

  2. _____ 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; 

Based on the preceding script, what is the value of the variable VAR1?

  1. _____ There is no value because the script generates an error.

  2. _____ 2

  3. _____ 6


The statement varray2(3).EXTEND

  1. _____ adds a third element to the third element of VARRAY2.

  2. _____ adds a second element to the third element of VARRAY2.

  3. _____ causes a 'Subscript beyond count' error.

Answers appear in Appendix A, Section 18.3 .

Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
Year: 2003
Pages: 289 © 2008-2017.
If you may any questions please contact us: