Lab 12.2 Self-Review Questions

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

1)	The benefits of module code are that it (check all that apply) _____ takes IN and OUT parameters. _____ can be called by many types of calling environments. _____ is stored in the database. _____ is always valid.
2)	All module code contains the following components (check all that apply): _____ Header _____ Footer _____ Declaration _____ Exception _____ Execution
3)	If a procedure has an IN parameter, then it must have an OUT parameter. _____ True _____ False
4)	Which are valid parameter definitions in the header of a parameter? (check all that apply) _____ P_LAST_NAME IN OUT VARCHAR2(20) _____ P_STUDID OUT IN NUMBER _____ P_ZIPCODE NUMBER _____ P_COURSE_COST IN NUMBER := 1095
5)	The view USER_SOURCE only contains the code of valid procedures. _____ True _____ False

Answers appear in Appendix A, Section 12.2 .