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:

Muscle Tension

The condition in which muscles remain semi-contracted for an extended period, often as a response to stress or physical exercise.

Orgasm

The climax of sexual stimulation, characterized by intense sexual pleasure and physiological responses like muscle contractions.

Myotonia

Increased muscle tension accompanying the approach of orgasm.

Bone Density

A measure of the amount of minerals (such as calcium) contained in a certain volume of bone, indicating its strength and risk for fracture.