Question 1

____ can be created only as stored program units.
A) Program units
B) Package specifications
C) Packages
D) Cursors

Accepted Answer

Only packages can be created as stored program units. Program units and cursors can be standalone units or part of a package, whereas package specifications are only used to define the interface for a package but do not contain any logic.

Question 2

The DEL command can be used to remove the package specification and body. _________________________

Accepted Answer

DROP

Question 3

The AUTHID CURRENT_USER clause is used to override definer-rights behavior. _________________________

Accepted Answer

The AUTHID CURRENT_USER clause specifies that the program unit executes with the rights of the current user rather than the definer. It is used to override definer-rights behavior.

Question 4

The term ____ refers to the range of visibility for a particular element or construct contained in a package.
A) package scope
B) package specification
C) package body
D) forward declaration

Accepted Answer

The term "package scope" refers to the visibility range of constructs or elements contained within a package. The scope can be controlled by accessing it through the package's specification, which defines what is visible to users outside of the package, and the package's body, which contains the implementation details of the constructs. Forward declaration is a concept used in some programming languages to define a construct before it is fully implemented, and is not directly related to package scope.

Question 5

The USER_OBJECTS data dictionary view allows us to view the source code of packages. _________________________

Accepted Answer

USER_SOURCE

Question 6

A(n) program declaration is a declaration of a program unit in a package body by placing the header code at the top of the package body code. _________________________

Accepted Answer

forward declaration

Question 7

Using the same name on multiple program units within the same package is referred to as ____.
A) overloading
B) declaring
C) initializing
D) referencing

Accepted Answer

Using the same name on multiple program units within the same package is known as overloading. This is because each program unit can have different parameters or attributes, allowing for multiple versions of the same name to exist within the same package.

Question 8

Package elements are considered ____ if they can be called only from other program units within the same package.
A) public
B) overloaded
C) one time procedures
D) private

Accepted Answer

Private elements within a package can only be called by other program units within the same package, making them inaccessible from other parts of the program. This allows for encapsulation and more controlled access to certain elements within the package.

Question 9

Package elements that can be referenced from outside the package are considered ____.
A) public
B) overloaded
C) one time only procedures
D) private

Accepted Answer

Public elements of a package are accessible from outside the package, while private elements are not. Overloaded refers to having multiple definitions of a function or procedure with different parameters. One time only procedures are not a common programming concept.

Question 10

A(n) ____ is a statement used to define a data construct, such as a variable, name, and data type.
A) package specification
B) package header
C) declaration
D) initialization

Accepted Answer

A declaration is a statement used to define a data construct, such as a variable, name, and data type. A package specification (A) is a declaration that defines the public interface of a package. A package header (B) is the first line of a package specification and contains the keyword "PACKAGE" followed by the name of the package. Initialization (D) refers to the process of assigning an initial value to a variable.

Question 11

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.

Accepted Answer

D) Items declared in the body that are not in the specification are indeed allowed and can be used by other procedures and functions within the same package body, making it incorrect to say the package body cannot include such declarations.

Question 12

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;

Accepted Answer

CA) is correct because it correctly uses "CREATE OR REPLACE PACKAGE BODY" followed by the package name "ordering_pkg" and includes both the procedure and function as defined in the package specification.C) is incorrect because it only includes the function and not the procedure, which is required as per the package specification.

Question 13

A(n) ____ is a declaration of a program unit in a package body by placing the header code at the top of the package body code.
A) package scope
B) package declaration
C) package specification
D) forward declaration

Accepted Answer

A forward declaration is used to declare a subprogram or other program unit within a package body before defining it, allowing the program unit to be referenced before it is fully defined.

Question 14

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;
The code fragment above is an example of a(n) ____.
A) anonymous block
B) package body
C) package specification
D) package scope

Accepted Answer

The code fragment is a package specification, as it starts with the keyword "CREATE OR REPLACE PACKAGE" and contains PROCEDURE and FUNCTION declarations. A package body would follow with the keyword "CREATE OR REPLACE PACKAGE BODY" and implement the functions and procedures declared in the specification. The package scope refers to the visibility of variables and objects declared within a package, which is not relevant to this code fragment. An anonymous block would start with the keyword "BEGIN" and end with the keyword "END;" and is used for procedural code execution outside of a packaged procedure or function.

Question 15

If a cursor is declared in a package specification that referenced the PV_TOTAL_NUM package variable, the variable ____.
A) need not be declared
B) must be declared after the cursor
C) must be declared as private
D) must be declared before the cursor

Accepted Answer

The PV_TOTAL_NUM package variable must be declared before the cursor as it is referenced in the cursor. If it is not declared beforehand, it will result in a compilation error.

Question 16

CREATE OR REPLACE PACKAGE metric_pkg IS cup_to_liter CONSTANT NUMBER := .24;
Pint_to_liter CONSTANT NUMBER := .47;
Qrt_to_liter CONSTANT NUMBER := .95;
END;
Which of the following statements about the code fragment above is correct?
A) The CONSTANT option allows the values of the variables to be modified.
B) There is no need to create a body for this package.
C) Program units are included in the package.
D) The package body must be created.

Accepted Answer

Since there are no program units included in the package, there is no need to create a body for the package. The package specification alone is sufficient. Also, the CONSTANT option does not allow the values of the variables to be modified.

Question 17

Full procedures or function codes are contained in the ____.
A) package specification
B) package body
C) package header
D) anonymous block

Accepted Answer

Full procedures or function codes are contained in the package body, not in the package specification or header. Anonymous blocks contain ad hoc code that is not necessarily part of a package.

Question 18

The AUTHID directive needs to be included in the package specification to clearly state the purity levels applicable to the function. _________________________

Accepted Answer

, PRAGMA RESTRICT_REFERENCES

Question 19

The USER_SOURCE data dictionary view is useful to identify what packages exist on the system. _________________________

Accepted Answer

USER_OBJECT

Question 20

The ____ is referred to as the package header.
A) purity level
B) construct scope
C) program units
D) package specification

Accepted Answer

The package header is referred to as the package specification, which defines the public interfaces of the package. The other options (A, B, and C) are unrelated to package specification.

Quiz 7: PL/SQL Packages

____ can be created only as stored program units.

The DEL command can be used to remove the package specification and body. _________________________

The AUTHID CURRENT_USER clause is used to override definer-rights behavior. _________________________

The term ____ refers to the range of visibility for a particular element or construct contained in a package.

The USER_OBJECTS data dictionary view allows us to view the source code of packages. _________________________

A(n) program declaration is a declaration of a program unit in a package body by placing the header code at the top of the package body code. _________________________

Using the same name on multiple program units within the same package is referred to as ____.

Package elements are considered ____ if they can be called only from other program units within the same package.

Package elements that can be referenced from outside the package are considered ____.

A(n) ____ is a statement used to define a data construct, such as a variable, name, and data type.

A(n) ____ is a declaration of a program unit in a package body by placing the header code at the top of the package body code.

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; The code fragment above is an example of a(n) ____.

If a cursor is declared in a package specification that referenced the PV_TOTAL_NUM package variable, the variable ____.

CREATE OR REPLACE PACKAGE metric_pkg IS cup_to_liter CONSTANT NUMBER := .24; Pint_to_liter CONSTANT NUMBER := .47; Qrt_to_liter CONSTANT NUMBER := .95; END; Which of the following statements about the code fragment above is correct?

Full procedures or function codes are contained in the ____.

The AUTHID directive needs to be included in the package specification to clearly state the purity levels applicable to the function. _________________________

The USER_SOURCE data dictionary view is useful to identify what packages exist on the system. _________________________

The ____ is referred to as the package header.