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

Full 1Z0-147 Practice