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.
You might also like to view...
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
The ____________________ creates the images, buttons, logos, and other art.
Fill in the blank(s) with the appropriate word(s).
CommView is an example of which of the following?
a. Key logger b. Packet sniffer c. Virus d. Tool for industrial espionage
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