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 .