Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

All of the following represent restrictions on functions, except ____.

Accepted Answer

A)  Functions cannot modify any tables in Oracle8i and prior versions. 
B)  Functions cannot be used in a CHECK constraint or as a default value of a table column. 
C)  If used in a remote or parallel operation, no reading or writing of packaged variables is allowed. 
D)  If used in a SELECT,VALUES, or SET clause, the function cannot write values to packaged variables. 
A)  Functions cannot modify any tables in Oracle8i and prior versions. 
B)  Functions cannot be used in a CHECK constraint or as a default value of a table column. 
C)  If used in a remote or parallel operation, no reading or writing of packaged variables is allowed. 
D)  If used in a SELECT,VALUES, or SET clause, the function cannot write values to packaged variables.

Question 3

The term ____________________ in packages refers to the ability to use the same name on multiple program units within the same package.

Accepted Answer

The answer of The term ____________________ in packages refers to...

Question 4

When compiling objects that call packaged program units, only the package specification or program unit header is used for verification.

Accepted Answer

A) True 
 B)False

Question 5

When compiling objects that call packaged program units, only the ____________________ is used for verification.

Accepted Answer

program un

Question 6

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

Accepted Answer

PRAGMA RES

Question 7

Packages can be created in local libraries, as can procedures and functions.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  package body 
B)  overloaded procedure 
C)  purity level 
D)  package scope 
A)  package body 
B)  overloaded procedure 
C)  purity level 
D)  package scope

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

All of the following represent restrictions on functions, except ____.

The term ____________________ in packages refers to the ability to use the same name on multiple program units within the same package.

When compiling objects that call packaged program units, only the package specification or program unit header is used for verification.

When compiling objects that call packaged program units, only the ____________________ is used for verification.

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

Packages can be created in local libraries, as can procedures and functions.

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 USER_OBJECTS data dictionary view allows us to view the source code of packages. _________________________

All of the following represent restrictions on functions, except ____.

The term ____________________ in packages refers to the ability to use the same name on multiple program units within the same package.

When compiling objects that call packaged program units, only the package specification or program unit header is used for verification.

When compiling objects that call packaged program units, only the ____________________ is used for verification.

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

Packages can be created in local libraries, as can procedures and functions.

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