Question 1

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

Accepted Answer

The answer of The ____________________ serves as a map to...

Question 2

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

Accepted Answer

A)  RESTRICT_REFERENCES(DEFAULT, WNDS, WNPS); 
B)  PRAGMA RESTRICT_REFERENCES(DEFAULT, WNDS, WNPS); 
C)  PRAGMA RESTRICT_REFERENCES(function_name, WNDS, WNPS); 
D)  RESTRICT_REFERENCES(function_name, WNDS, WNPS);

Question 3

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

Accepted Answer

A)  WNDS 
B)  RNDS 
C)  WNPS 
D)  RNPS

Question 4

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

Accepted Answer

A)  overloading 
B)  declaring 
C)  initializing 
D)  referencing

Question 5

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

Accepted Answer

A)  cursor 
B)  purity level 
C)  package scope 
D)  one time only procedure

Question 6

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

Accepted Answer

A)  public 
B)  overloaded 
C)  one time only procedures 
D)  private

Question 7

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.

Accepted Answer

The answer of A(n) ____________________ is a declaration of a...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  DROP PACKAGE BODY package_name; 
B)  DEL PACKAGE BODY package_name; 
C)  DROP PACKAGE package_name; 
D)  DEL PACKAGE package_name;

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  package scope 
B)  package specification 
C)  package body 
D)  forward declaration

Question 13

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

Accepted Answer

A)  anonymous block 
B)  package body 
C)  package specification 
D)  package scope

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

A) True 
 B)False

Question 17

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

Accepted Answer

A)  definer-rights 
B)  user-rights 
C)  user scope 
D)  invoker-rights

Question 18

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

Accepted Answer

A)  public 
B)  overloaded 
C)  one time procedures 
D)  private

Question 19

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

Accepted Answer

The answer of Elements declared in a package are considered...

Question 20

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

Accepted Answer

A) True 
 B)False

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