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 . |