Oracle® PL/SQL® Interactive Workbook, Second Edition By Benjamin Rosenzweig, Elena Silvestrova
Table of Contents
Appendix A. Answers to Self-Review Questions
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.