Question 1

When compiling objects that call packaged program units, which of the following statements is True?

Accepted Answer

A)  Restriction violations are not discovered until runtime. 
B)  Only the program body is used for verification. 
C)  Because only the package body information is used, the PL/SQL compiler cannot determine if the restrictions on functions within SQL statements are being respected. 
D)  Restriction violations are discovered at compile time. 
A)  Restriction violations are not discovered until runtime. 
B)  Only the program body is used for verification. 
C)  Because only the package body information is used, the PL/SQL compiler cannot determine if the restrictions on functions within SQL statements are being respected. 
D)  Restriction violations are discovered at compile time. A

Question 2

The term user scope is the range of visibility for a particular element or construct contained in a package. _________________________

Accepted Answer

A) True 
 B)False  False

Question 3

Define the term package, and explain why it is used.

Accepted Answer

A package is another type of PL/SQL construct that can house multiple program units and contain other constructs, such as variables and cursors. Using packages not only allows programmers to organize program units into related groups, but also enables the establishment of private program units, the sharing of variable values across program units, the overloading of program units, easier user privilege granting, and improved performance. Packages also lead to improved handling of dependencies.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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?

Accepted Answer

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

Question 7

A(n) ____________________ procedure is a procedure in a package that runs only once, when the package is initially invoked.

Accepted Answer

The answer of A(n) ____________________ procedure is a procedure in...

Question 8

One advantage that packages provide is that constructs, such as variables, cursors, types, and exceptions, declared in the specification are ____________________.

Accepted Answer

The answer of One advantage that packages provide is that...

Question 9

The ____________________ data dictionary view is also useful to identify what packages exist on the system.

Accepted Answer

The answer of The ____________________ data dictionary view is also...

Question 10

The ____ packaged function purity level does not modify database tables.

Accepted Answer

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

Question 11

The pragma level defines what type of data structures the function reads or modifies.

Accepted Answer

A) True 
 B)False

Question 12

The statement ____ would successfully declare a REF CURSOR data type.

Accepted Answer

A)  CREATE testcur as REF CURSOR; 
B)  TYPE testcur IS ref cursor; 
C)  TYPE testcur ref_cursor; 
D)  testcur REF_CURSOR; 
A)  CREATE testcur as REF CURSOR; 
B)  TYPE testcur IS ref cursor; 
C)  TYPE testcur ref_cursor; 
D)  testcur REF_CURSOR;

Question 13

What is meant by the term package body?

Accepted Answer

A package body is the program unit that

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;
When creating a package body for the package specification above, which of the following statements is incorrect?

Accepted Answer

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

Question 15

A package specification can contain declarations for procedures, functions, variables, exceptions, cursors, and types.

Accepted Answer

A) True 
 B)False

Question 16

When the values of package element persist throughout a user session and, therefore, can be referenced in code within various parts of the application during a user session, the elements are considered to be global. _________________________

Accepted Answer

A) True 
 B)False

Question 17

The query to be used to populate a ____________________ data type can be determined at run time.

Accepted Answer

The answer of The query to be used to populate...

Question 18

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

Accepted Answer

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

Question 19

Developers can use the PRAGMA RESTRICT_REFERENCES compiler instruction to indicate the purity level of the function in the package specification.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

When compiling objects that call packaged program units, which of the following statements is True?

The term user scope is the range of visibility for a particular element or construct contained in a package. _________________________

Define the term package, and explain why it is used.

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

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

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(n) ____________________ procedure is a procedure in a package that runs only once, when the package is initially invoked.

One advantage that packages provide is that constructs, such as variables, cursors, types, and exceptions, declared in the specification are ____________________.

The ____________________ data dictionary view is also useful to identify what packages exist on the system.

The ____ packaged function purity level does not modify database tables.

The pragma level defines what type of data structures the function reads or modifies.

The statement ____ would successfully declare a REF CURSOR data type.

What is meant by the term package body?

A package specification can contain declarations for procedures, functions, variables, exceptions, cursors, and types.

When the values of package element persist throughout a user session and, therefore, can be referenced in code within various parts of the application during a user session, the elements are considered to be global. _________________________

The query to be used to populate a ____________________ data type can be determined at run time.

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

Developers can use the PRAGMA RESTRICT_REFERENCES compiler instruction to indicate the purity level of the function in the package specification.

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

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

When compiling objects that call packaged program units, which of the following statements is True?

The term user scope is the range of visibility for a particular element or construct contained in a package. _________________________

Define the term package, and explain why it is used.

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

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

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(n) ____________________ procedure is a procedure in a package that runs only once, when the package is initially invoked.

One advantage that packages provide is that constructs, such as variables, cursors, types, and exceptions, declared in the specification are ____________________.

The ____________________ data dictionary view is also useful to identify what packages exist on the system.

The ____ packaged function purity level does not modify database tables.

The pragma level defines what type of data structures the function reads or modifies.

The statement ____ would successfully declare a REF CURSOR data type.

What is meant by the term package body?

A package specification can contain declarations for procedures, functions, variables, exceptions, cursors, and types.

When the values of package element persist throughout a user session and, therefore, can be referenced in code within various parts of the application during a user session, the elements are considered to be global. _________________________

The query to be used to populate a ____________________ data type can be determined at run time.

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

Developers can use the PRAGMA RESTRICT_REFERENCES compiler instruction to indicate the purity level of the function in the package specification.

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

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