In order to test your progress, you should be able to answer the following questions.
An exception defined in the inner block can be raised in
_____ both inner and outer blocks.
_____ the outer block only.
_____ the inner block only.
If an exception has been raised in the inner block and has been handled in the outer block, control is transferred back to inner block for further execution of the script.
If an exception has been raised in the outer block, and its handler is defined in the inner block, which of the following will occur?
_____ Control will be passed to the inner block to handle the raised exception.
_____ The script will terminate due to an exception that is not handled.
An exception defined inside the body of the loop
_____ terminates this loop after it has been raised.
_____ allows the loop to proceed with next iteration.
_____ causes an error.
A WHEN clause of the exception-handling section of a PL/SQL block can reference a single exception only.
Answers appear in Appendix A, Section 10.1 .