CREATE OR REPLACE PACKAGE Ordering_pkg IS

question 54

Multiple Choice

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;

---

Definitions:

Antipyretic

A type of medication used to reduce or prevent fever.

Pyrogenic

Capable of producing fever or raising the body temperature.

Antipyretic

A medication used to reduce or prevent fever.

Febrile

Pertaining to or characterized by fever; indicating an elevated body temperature often due to infection or illness.