In order to test your progress, you should be able to answer the following questions.
SQL statements combined into PL/SQL blocks cause an increase in the network traffic.
Which of the following sections is mandatory for a PL/SQL block?
_____ Exception-handling section
_____ Executable section
_____ Declaration section
The exception-handling section in a PL/SQL block is used to
_____ handle compilation errors.
_____ handle runtime errors.
_____ handle both compilation and runtime errors.
A PL/SQL compiler can detect
_____ syntax errors.
_____ runtime errors.
_____ both compilation and runtime errors.
P-code is stored in the database for
_____ anonymous PL/SQL blocks.
_____ named PL/SQL blocks.
Answers appear in Appendix A, Section 2.1 .