Lab 18.1 Self-Review Questions

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


The main difference between the index-by and nested tables is that

  1. _____ nested tables can be stored in a database column, and index-by tables cannot.

  2. _____ index-by tables can be stored in a database column, and nested tables cannot.


An index-by table is indexed by what datatype?

  1. _____ NUMBER

  2. _____ INTEGER


  4. _____ PLS_INTEGER


A nested table must be initialized prior to its use.

  1. _____ True

  2. _____ False


If a PL/SQL table contains one element

  1. _____ the FIRST method returns value of one, and the LAST method returns NULL.

  2. _____ the FIRST method returns NULL, and the LAST method returns value of one.

  3. _____ the FIRST and LAST methods return a value of one.

  4. _____ referring to these methods causes an error.


If a PL/SQL table has eight elements, the DELETE (3, 7) method deletes

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

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

  3. _____ elements three to seven.

Answers appear in Appendix A, Section 18.1 .

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: