試題詳解

QUESTION 111 Which 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.