Question 1

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

Accepted Answer

A)  PRAGMA REFERENCES 
B)  PRAGMA RESTRICT 
C)  PRAGMA RESTRICT_REFERENCES 
D)  RESTRICT_REFERENCES 
A)  PRAGMA REFERENCES 
B)  PRAGMA RESTRICT 
C)  PRAGMA RESTRICT_REFERENCES 
D)  RESTRICT_REFERENCES

Question 2

All code in the procedure and function header sections of a package body must match exactly to the declarations in the corresponding specification.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  package specification 
B)  package header 
C)  declaration 
D)  initialization 
A)  package specification 
B)  package header 
C)  declaration 
D)  initialization

Question 4

Adding the program unit name to the END statement that closes the procedure or function statements in the package body is mandatory.

Accepted Answer

A) True 
 B)False

Question 5

Functions are used in CHECK constraints or as a default values of table columns.

Accepted Answer

A) True 
 B)False

Question 6

A(n) package body is the program unit that contains the code for any procedures and functions declared in the specification. _________________________

Accepted Answer

A) True 
 B)False

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

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

Question 8

Full procedures or function codes are contained in the ____.

Accepted Answer

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

Question 9

For overloading to be successful, the formal parameters in the procedures or functions must be the same.

Accepted Answer

A) True 
 B)False

Question 10

When a user assumes the rights of the program unit owner just during the processing of that program unit, this is referred to as ____.

Accepted Answer

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

Question 11

The ____ is referred to as the package header.

Accepted Answer

A)  purity level 
B)  construct scope 
C)  program units 
D)  package specification 
A)  purity level 
B)  construct scope 
C)  program units 
D)  package specification

Question 12

Packaged variable values are persistent throughout a user session and each user of the package has his or her own copy of the packaged variable.

Accepted Answer

A) True 
 B)False

Question 13

Why would a package require two procedures or functions with the same name?

Accepted Answer

The feature of overloading in pac

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;
Based on the package specification above, which of the following code fragments correctly creates a package body?

Accepted Answer

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; 
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;

Question 15

Functions cannot be used in a(n) ____________________ constraint or as a default value of a table column.

Accepted Answer

The answer of Functions cannot be used in a(n) ____________________...

Question 16

All of the following represent packaged function purity levels, except ____.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

____ can be created only as stored program units.

Accepted Answer

A)  Program units 
B)  Package specifications 
C)  Packages 
D)  Cursors 
A)  Program units 
B)  Package specifications 
C)  Packages 
D)  Cursors

Question 19

A REEF CURSOR data type declared in a package specification may be referenced by multiple program units.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of The ____________________ data dictionary view allows us...

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

All code in the procedure and function header sections of a package body must match exactly to the declarations in the corresponding specification.

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

Adding the program unit name to the END statement that closes the procedure or function statements in the package body is mandatory.

Functions are used in CHECK constraints or as a default values of table columns.

A(n) package body is the program unit that contains the code for any procedures and functions declared in the specification. _________________________

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.

Full procedures or function codes are contained in the ____.

For overloading to be successful, the formal parameters in the procedures or functions must be the same.

When a user assumes the rights of the program unit owner just during the processing of that program unit, this is referred to as ____.

The ____ is referred to as the package header.

Packaged variable values are persistent throughout a user session and each user of the package has his or her own copy of the packaged variable.

Why would a package require two procedures or functions with the same name?

Functions cannot be used in a(n) ____________________ constraint or as a default value of a table column.

All of the following represent packaged function purity levels, except ____.

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

____ can be created only as stored program units.

A REEF CURSOR data type declared in a package specification may be referenced by multiple program units.

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

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters

Exam 7: PL/SQL Packages

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

All code in the procedure and function header sections of a package body must match exactly to the declarations in the corresponding specification.

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

Adding the program unit name to the END statement that closes the procedure or function statements in the package body is mandatory.

Functions are used in CHECK constraints or as a default values of table columns.

A(n) package body is the program unit that contains the code for any procedures and functions declared in the specification. _________________________

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.

Full procedures or function codes are contained in the ____.

For overloading to be successful, the formal parameters in the procedures or functions must be the same.

When a user assumes the rights of the program unit owner just during the processing of that program unit, this is referred to as ____.

The ____ is referred to as the package header.

Packaged variable values are persistent throughout a user session and each user of the package has his or her own copy of the packaged variable.

Why would a package require two procedures or functions with the same name?

Functions cannot be used in a(n) ____________________ constraint or as a default value of a table column.

All of the following represent packaged function purity levels, except ____.

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

____ can be created only as stored program units.

A REEF CURSOR data type declared in a package specification may be referenced by multiple program units.

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

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters