CREATE OR REPLACE PACKAGE ordering_pkgIS 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?

Question

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;
 

Answer 1

Answer: A