O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required