| 1) |
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. |
| 2) |
The parameters of a function must be labeled IN or the function will not compile successfully._____ True _____ False |
| 3) |
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 |
| 4) |
IN OUT parameters are permissible in functions._____ True _____ False _____ The function will compile with an IN OUT parameter, but it is not advisable to use them. |
| 5) |
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. |
لطفا منتظر باشید ...
