Lab 14.1 Self-Review Questions

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

1)	The main advantages to grouping procedures and functions into packages are (check all that apply): _____ It follows the trendy object method of programming. _____ It is a more efficient way of utilizing the processor memory. _____ It makes greater use of the security privileges of various users. _____ It is a more efficient method to maximize tablespace storage. _____ It keeps you on good terms with the DBA.
2)	If user Tashi has SELECT privilege on the student table and user Sonam does not, then Sonam can make use of a procedure created by Tashi to get access to the student table if he has execute privileges on Tashi's procedure. _____ True _____ False
3)	All procedures and functions in a package body must be declared in the package specification. _____ True _____ False
4)	The initialization section of a package refers to _____ another term for the package header. _____ the first part of the package. _____ the executable code at the end of the package. _____ the evolutionary rudiments in code that are left over from programming methods of cavemen.
5)	The package specification is merely a formality for other programmers to let them know what parameters are being passed in and out of the procedures and functions. It hides the program logic but in actuality it is not necessary and is incorporated into the package body. _____ True _____ False

Answers appear in Appendix A, Section 14.1 .