Which statement is valid when removing procedures?
A.
Use a drop procedure statement to drop a standalone procedure.
B.
Use a drop procedure statement to drop a procedure that is part of a package.
Then recompile the package specification.
C.
Use a drop procedure statement to drop a procedure that is part of a package.
Then recompile the package body.
D.
For faster removal and re-creation, do not use a drop procedure statement.
Instead, recompile the procedure using the alter procedure statement with the REUSE SETTINGS
clause.
Explanation:
The DROP DROCEDURE statement is used to drop a stand alone procedure
Incorrect Answers:
B: You can’t drop a procedure that’s inside a package, you have to drop the package, and in this
case the whole procedures, functions,… that are inside the packages will be droped.
C: Same as B.
D: REUSE SETTINGS is used to to prevent Oracle from dropping and reacquiring compiler switch
settings.With this clause, Oracle preserves the existing settings and uses them for the
recompilation.