Exam 7: PL/SQL Packages

The ____________________ serves as a map to what program units are available in the package and the parameters of the program unit.

Which of the following correctly sets the default purity level for a packaged function?

The ____ packaged function purity level does not modify packaged variables.

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

The ____ defines the type of data structures the function reads or modifies.

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

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.

Functions written in other languages such as JAVA can also be called from Oracle programs.

The statement ____ would successfully remove the package specification and body.

Functions that have not been declared in a package specification are considered public.

Items declared in the package body and not in the specification can be used only by other procedures and functions within this same package body.

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

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) ____.

Package code is not cached, nor is package data such as variables and cursors.

A one time only procedure is included in a package body as an anonymous PL/SQL block at the end of the body code.

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. _________________________

Forcing the user to use his or her own privileges for a program unit, and not that of the owner is called ____.

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

Elements declared in a package are considered ____________________ if they can be called only from other program units within the same package.

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