Oracle® PL/SQL® Interactive Workbook, Second Edition

Chapter 2 PL/SQL Concepts

Lab 2.1 ▪ Self-Review Answers

A1:	Questions Answers Comments 1) B When the SELECT statements are combined into a PL/SQL program, they are sent to the server as a single unit thus reducing network traffic.
A2:	Questions Answers Comments 2) B Executable section is the only mandatory section for a PL/SQL block. As a result, BEGIN NULL; -- null statement END; is a valid PL/SQL block.
A3:	Questions Answers Comments 3) B When a runtime error occurs in the PL/SQL block, control is passed to the exception-handling section of the block, where the error is evaluated and a specific exception is raised or executed.
A4:	Questions Answers Comments 4) A A PL/SQL compiler is able to detect only syntax errors. It cannot detect ...