In order to test your progress, you should be able to answer the following questions.
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.
All module code contains the following components (check all that apply):
_____ Header
_____ Footer
_____ Declaration
_____ Exception
_____ Execution
If a procedure has an IN parameter, then it must have an OUT parameter.
_____ True
_____ False
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
The view USER_SOURCE only contains the code of valid procedures.
Answers appear in Appendix A, Section 12.2 .