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...

CommView is an example of which of the following?

a. Key logger b. Packet sniffer c. Virus d. Tool for industrial espionage

Computer Science & Information Technology

Which of the following is commonly done as part of a vulnerability scan?

A. Exploiting misconfigured applications B. Cracking employee passwords C. Sending phishing emails to employees D. Identifying unpatched workstations

Computer Science & Information Technology

Which of the following would NOT be a benefit of a home network?

a. Multiple devices can connect to the internet. b. Some devices have special functions when connected to the network. c. Files are more secure when stored on a home network d. Files can be shared between devices connected to the network

Computer Science & Information Technology

The ____________________ creates the images, buttons, logos, and other art.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology