Oracle
1Z0-147 · Question #43
1Z0-147 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
Question
Examine this package:
CREATE OR REPLACE PACKAGE discounts
IS
g_id_number := 7829;
g_discount_rate NUMBER := 0.00;
PROCEDURE display_price (p_price NUMBER);
END discounts;
/
CREATE OR REPLACE PACKAGE BODY discounts
IS
PROCEDURE display_price (p_price NUMBER)
IS
BEGIN
DBMS_OUTPUT.PUT_LINE ('Discounted ' ||
TO_CHAR(p_priceNVL(discount_rate, 1)));
END display_price;
BEGIN
discount_rate := 0.10;
END discounts;
/
The SQLPlus SERVEROUTPUT setting is turned on in your session. You execute the procedure DISPLAY_PRICE from SQL*Plus with the command: EXECUTE discounts.display_price (100);
What is the result?
Options
- AA. Discounted 10
- BB. Discounted 100
- CC. Discounted 0.00
- DD. Discounted NULL
- EE. Discounted 0.10
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.