Oracle PL[s]SQL by Example

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

1)

One of the differences between the nested tables and varrays is that

  1. _____ nested tables can be sparse, and varrays cannot.

  2. _____ varrays can be sparse, and nested tables cannot.

2)

A varray has an upper bound that

  1. _____ can be extended without any limits.

  2. _____ can be extended to its maximum size.

  3. _____ is fixed and cannot be extended to all.

3)

A varray must be initialized prior to its use.

  1. _____ True

  2. _____ False

4)

If a varray has maximum size of 5 and contains 2 elements

  1. _____ the LIMIT and COUNT methods return the same value of 5.

  2. _____ the LIMIT and COUNT methods return the same value of 2.

  3. _____ the LIMIT method returns the value of 5, and the COUNT method returns the value of 2.

5)

If a varray has eight elements, the DELETE (3, 7) method

  1. _____ deletes the third and seventh elements of the collection.

  2. _____ deletes the third element and ignores the seventh element of the collection.

  3. _____ deletes the elements three to seven.

  4. _____ causes an error.

Answers appear in Appendix A, Section 18.2 .

Related

Категории