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

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

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 Hint

Leave a Reply 7

Your email address will not be published. Required fields are marked *

Alisa

Alisa

Packaged public variables and cursors persist for the duration of a session. They can be shared by all subprograms that execute in the environment. They let you maintain data across transactions without storing it in the database. When you invoke a packaged subprogram for the first time, the whole package is loaded into memory.

Reply