Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources] نسخه متنی

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.