Exam 1z0-144 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-144

Question #: 34
Topic #: 1

[All 1z0-144 Questions]

Which two statements are correct about PL/SQL package components? (Choose two)

A. A package must have both specification and body.
B. A package body can exist without the package specification.
C. A package specification can exist without the package body.
D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

Show Suggested Answer

Suggested Answer: CD 🗳️

by Naveen_2022 at July 27, 2022, 6:51 p.m.

Comments

Submit Cancel

Naveen_2022

2 years, 10 months ago

Yes, CD is correct. Explanation (Thanks to Paul): “You can code and compile specifications without their bodies. Next, you can compile standalone subprograms that reference the packages. You need not fully define the package bodies until you are ready to complete the application.” “Package public variables and cursors can persist for the life of a session. They can be shared by all subprograms that run in the environment. They let you maintain data across transactions without storing it in the database. ” “The first time you invoke a package subprogram, Oracle Database loads the whole package into memory. Subsequent invocations of other subprograms in same the package require no disk I/O.”

upvoted 1 times

...