QUESTION 111Which statement is valid when removing procedures?short 單行
(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.