Which statement is true about removing packages?
A.
You must remove the package body first
B.
Removing a package specification removes the body too
C.
Removing the package body removes the specification too
D.
You must remove both the package body and the specification separately
E.
Removing a package specification removes all stand alone stored functions named in the specification
Explanation:
Answer D is incorrect
To remove the package specification and the package body you use the command:
DROP PACKAGE <Package_Name>
To remove the package body from the database, you use the following command:
DROP PACKAGE BODY <Package_Name>
Answer B is the correct response – Removing a package specification removes the body too.