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