Which statement is valid when removing procedures?

A. Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package body.
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 standalone procedure.
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.

Answer: C. Use a drop procedure statement to drop a standalone procedure.

Computer Science & Information Technology

You might also like to view...

Microsoft Edge's ________ feature provides a clean and simple layout to make reading webpages easier

A) Reading List B) Hub C) Reading View D) Blog

Computer Science & Information Technology

The Solver ________ Report displays various statistical characteristics about the given model, such as how many variables and rows it contains

Fill in the blank(s) with correct word

Computer Science & Information Technology