Which two statements are true regarding a PL/SQL package body?

Which two statements are true regarding a PL/SQL package body? (Choose two.)

Which two statements are true regarding a PL/SQL package body? (Choose two.)

A.
It cannot be created without a package specification.

B.
It cannot invoke subprograms defined in other packages.

C.
It can contain only the subprograms defined in the package specification.

D.
It can be changed and recompiled without making the package specification invalid.

Explanation:
Package Specification and Body
Package bodies:
Are separate from package specifications. Because of this, the code of the body can be changed
and recompiled, and other objects that are dependent on the specification are not marked invalid.
Contain the code for subprograms defined in the package specification. This is where the work is
done. The specification shows how to call subprograms within the package: the body is the code
section
Cannot be compiled unless the package specification has already been compiled. You can
create a specification without a body- but you cannot create a body without a specification.
May be wrapped to hide details of the code. Wrap is a stand-alone program that obfuscates PL
SQL source code so that you can deliver PL SQL applications without exposing your source code.
For more information about the use of wrap, see the PL/SQL Packages and Types Reference.



Leave a Reply 0

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