Chapter 14 Packages

Lab 14.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) B When a package is first called, all the procedures and functions in that package are brought into memory and will run quickly when they are used in the same session.
A2:
Questions Answers Comments
2) A 
A3:
Questions Answers Comments
3) B Procedures and functions that are not declared in the package specification will be private.
A4:
Questions Answers Comments
4) C 
A5:
Questions Answers Comments
5) B A package specification is a database object and must be compiled prior to compiling the package body. This can be done in one or two scripts.

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial