Oracle
1Z0-147 · Question #21
1Z0-147 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
Question
Examine this code:
CREATE OR REPLACE PACKAGE metric_converter
IS
c_height CONSTANT NUMBER := 2.54;
c_weight CONSTANT NUMBER := .454;
FUNCTION calc_height (p_height_in_inches NUMBER)
RETURN NUMBER;
FUNCTION calc_weight (p_weight_in_pounds NUMBER)
RETURN NUMBER;
END;
/
CREATE OR REPLACE PACKAGE BODY metric_converter
IS
FUNCTION calc_height (p_height_in_inches NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN p_height_in_inches * c_height;
END calc_height;
FUNCTION calc_weight (p_weight_in_pounds NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN p_weight_in_pounds * c_weight;
END calc_weight;
END metric_converter;
/
CREATE OR REPLACE FUNCTION calc_height (p_height_in_inches NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN p_height_in_inches * metric_converter.c_height;
END calc_height;
/
Which statement is true?
Options
- AIf you remove the package specification, then the package body and the stand alone stored function CALC_HEIGHT are removed.
- BIf you remove the package body, then the package specification and the stand alone stored function CALC_HEIGHT are removed.
- CIf you remove the package specification, then the package body is removed.
- DIf you remove the package body, then the package specification is removed.
- EIf you remove the package stored function CALC_HEIGHT , then the METRIC_CONVERTER package body and the package specification are removed.
- FThe stand alone function CALC_HEIGHT cannot be created because its name is used in a packaged function.
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.