Lab 18.1 Self-Review Questions

[ Team LiB ]

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.

[ Team LiB ]