In order to test your progress, you should be able to answer the following questions.
What are the distinguishing characteristics that make functions different from procedures? (check all that apply)
_____ Functions require a PRAGMA RESTRICT clause.
_____ Functions only take IN parameters.
_____ Functions are stored in the database.
_____ Functions require a return value.
The parameters of a function must be labeled IN or the function will not compile successfully.
_____ True
_____ False
Which statement(s) will cause control to return to the calling environment in a function? (check all that apply)
_____ The raising of an exception
_____ The initialization of an OUT parameter
_____ Writing to a database table
_____ The RETURN statement
IN OUT parameters are permissible in functions.
_____ The function will compile with an IN OUT parameter, but it is not advisable to use them.
If a function declares a user -defined exception but never explicitly raises the exception, which of the following will be true?
_____ The function will not be able to compile.
_____ The function will fail a purity level check.
_____ The exception will never be raised.
_____ As long as the exception has a RETURN clause, there is no error in having a user-defined exception and not calling it.
Answers appear in Appendix A, Section 13.1 .