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

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