CREATE OR REPLACE PACKAGE ordering_pkg IS
Pv_total_num NUMBER(3,2);
PROCEDURE order_total_pp
(p_bsktid IN NUMBER,
P_sub OUT NUMBER);
FUNCTION ship_calc_pf
(p_qty IN NUMBER)
RETURN NUMBER;
END;
Based on the package specification above, which of the following code fragments correctly creates a package body?
A) CREATE OR REPLACE PACKAGE BODY ordering_pkg IS FUNCTION ship_calc_pf
(p_qty IN NUMBER)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
... code detail ...
END ship_calc_pf;
PROCEDURE order_total_pp
(p_bsktid IN NUMBER,
P_sub OUT NUMBER)
IS
BEGIN
... code detail ...
END order_total_pp;
END;
B) CREATE OR REPLACE PACKAGE ordering_pkg IS FUNCTION ship_calc_pf
(p_qty IN NUMBER)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
... code detail ...
END ship_calc_pf;
PROCEDURE order_total_pp
(p_bsktid IN NUMBER,
P_sub OUT NUMBER,
IS
BEGIN
... code detail ...
END order_total_pp;
END;
C) CREATE OR REPLACE PACKAGE BODY ordering_pkg IS FUNCTION ship_calc_pf
(p_qty IN NUMBER)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
... code detail ...
END ship_calc_pf;
END;
D) CREATE OR REPLACE PACKAGE BODY order_pkg IS FUNCTION ship_calc_pf
(p_qty IN NUMBER)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
... code detail ...
END ship_calc_pf;
PROCEDURE order_total_pp
(p_bsktid IN NUMBER,
P_sub OUT NUMBER)
IS
BEGIN
... code detail ...
END order_total_pp;
END;

Question

Quizplus · Accepted Answer

CA) is correct because it correctly uses "CREATE OR REPLACE PACKAGE BODY" followed by the package name "ordering_pkg" and includes both the procedure and function as defined in the package specification.C) is incorrect because it only includes the function and not the procedure, which is required as per the package specification.

CREATE OR REPLACE PACKAGE Ordering_pkg IS