Multiple Choice
CREATE OR REPLACE PACKAGE product_info_pkg IS PROCEDURE prod_search_pp
(p_id IN bb_product.idproduct%TYPE,
P_sale OUT bb_product.saleprice%TYPE,
P_price OUT bb_product.price%TYPE) ;
PROCEDURE prod_search_pp
(p_id IN bb_product.productname%TYPE,
P_sale OUT bb_product.saleprice%TYPE,
P_price OUT bb_product.price%TYPE) ;
END;
The code fragment above is an example of a(n) ____.
A) package body
B) overloaded procedure
C) purity level
D) package scope
Correct Answer:

Verified
Correct Answer:
Verified
Q58: _ can be created only as stored
Q59: A REEF CURSOR data type declared in
Q60: The _ data dictionary view allows us
Q61: The <u>USER_OBJECTS</u> data dictionary view allows us
Q62: All of the following represent restrictions on
Q63: The term _ in packages refers to
Q64: When compiling objects that call packaged program
Q65: When compiling objects that call packaged program
Q66: The _ directive needs to be included
Q67: Packages can be created in local libraries,