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;
When creating a package body for the package specification above, which of the following statements is incorrect?
A) The package body must be created using the same name as the existing specification.
B) All code in the procedure and function header sections in the package body must match exactly to the declarations in the corresponding specification.
C) The package body cannot include declarations of variables, cursors, types, and program units not found in the corresponding specification.
D) Items declared in the body and not in the specification can be used only by other procedures and functions within this same package body.
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The _ data dictionary view is also
Q10: The _ packaged function purity level does
Q11: The pragma level defines what type of
Q12: The statement _ would successfully declare a
Q13: What is meant by the term package
Q15: A package specification can contain declarations for
Q16: When the values of package element persist
Q17: The query to be used to populate
Q18: If a cursor is declared in a
Q19: Developers can use the PRAGMA RESTRICT_REFERENCES compiler