Cheight end calcheight which statement is true a if

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ight_in_inches NUMBER) RETURN NUMBER IS BEGIN RETURN p_height_in_inches * metric_converter.c_height; END calc_height; / Which statement is true? A. If you remove the package specification, then the package body and the stand alone Actualtests.com - The Power of Knowing 1Z0-147 stored function CALC_HEIGHT are removed. B. If you remove the package body, then the package specification and the stand alone stored function CALC_HEIGHT are removed. C. If you remove the package specification, then the package body is removed. D. If you remove the package body, then the package specification is removed. E. If you remove the stand alone stored function CALC_HEIGHT, then the METRIC_CONVERTER package body and the package specification are removed. F. The stand alone function CALC_HEIGHT cannot be created because its name is used in a packaged function. Answer: C Explanation: If you remove the package specification, the package body will be removed. To remove the package specification and the package body from the database, you use the following syntax: DROP PACKAGE ; The DROP PACKAGE statement removes both the package specification and the package body from the database. Incorrect Answers A. If you remove the package specification the package body will also be deleted. To delete a stand-alone procedure you must issue a DROP PROCEDURE ProcedureName command. B. If you remove the package body only the package body is removed by the DROP PACKAGE BODY command. To delete the package specification and the package body you issue a DROP PACAKGE Command. Droppig a Package has no impact on stand-alone procedures. D. The DROP PACKAGE BODY statement removes only the package body. The package specification remains intact in the database. The status of the package specification remains VALID even if the corresponding package body is dropped from the database. To remove only the package body from the database, you use the following syntax: DROP PACKAGE BODY ; E. Dropping a stand-alone procedure or function does not drop any package objects. F. You m...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online