Question 1

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 2

What is meant by the term package body?

Accepted Answer

A package body is the program unit that ...

Question 3

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.E) B) and D)
F) A) and B)

Question 4

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 5

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

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.E) All of the above
F) B) and C)

Question 7

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

Accepted Answer

A)   RNDS
B)   WNDS
C)   WNPS
D)   RNPSE) A) and B)
F) B) and C)

Question 8

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 cursorE) None of the above
F) B) and D)

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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;E) A) and B)
F) C) and D)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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.E) None of the above
F) All of the above A

Question 13

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

Question 14

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 15

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 16

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 17

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 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 7: PL/SQL Packages

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

Correct Answer
verified

What is meant by the term package body?

Correct Answer
verified
A package body is the program unit that ...
View Answer

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
A

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

Correct Answer
verified

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

Correct Answer
verified

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

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

Correct Answer
verified

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

Correct Answer
verified
False

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 7: PL/SQL Packages

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

Correct AnswerverifiedShow Answer

What is meant by the term package body?

Correct AnswerverifiedA package body is the program unit that ...View AnswerShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
A package body is the program unit that ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified