Lab 18.1 Self-Review Questions

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

1)	The main difference between the index-by and nested tables is that _____ nested tables can be stored in a database column, and index-by tables cannot. _____ index-by tables can be stored in a database column, and nested tables cannot.
2)	An index-by table is indexed by what datatype? _____ NUMBER _____ INTEGER _____ BINARY_INTEGER _____ PLS_INTEGER
3)	A nested table must be initialized prior to its use. _____ True _____ False
4)	If a PL/SQL table contains one element _____ the FIRST method returns value of one, and the LAST method returns NULL. _____ the FIRST method returns NULL, and the LAST method returns value of one. _____ the FIRST and LAST methods return a value of one. _____ referring to these methods causes an error.
5)	If a PL/SQL table has eight elements, the DELETE (3, 7) method deletes _____ the third and seventh elements of the collection. _____ the third element and ignores the seventh element of the collection. _____ elements three to seven.

Answers appear in Appendix A, Section 18.1 .