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 |