Question 1

Which of the following statements is True?

Accepted Answer

A)  Modifications to a package body changes the status of dependent objects. 
B)  Modifications to a package body does not change the status of independent objects. 
C)  Modifications to a package header does not change the status of dependent objects. 
D)  Modifications to a package body does not change the status of dependent objects. 
A)  Modifications to a package body changes the status of dependent objects. 
B)  Modifications to a package body does not change the status of independent objects. 
C)  Modifications to a package header does not change the status of dependent objects. 
D)  Modifications to a package body does not change the status of dependent objects.

Question 2

A program unit is said to contain ____ when it includes references to database objects that in turn references other database objects.

Accepted Answer

A)  remote dependencies 
B)  user_dependencies 
C)  direct dependencies 
D)  indirect dependencies 
A)  remote dependencies 
B)  user_dependencies 
C)  direct dependencies 
D)  indirect dependencies

Question 3

The %TYPE declaration instructs the system to assign the variable data type based on the underlying table column data type at runtime. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Which compile statement option forces a program unit to retain the compilation settings from the previous compile action?

Accepted Answer

A)  REUSE SETTINGS 
B)  RESET SETTINGS 
C)  REUSE PARAMETERS 
D)  REUSE COMPILER 
A)  REUSE SETTINGS 
B)  RESET SETTINGS 
C)  REUSE PARAMETERS 
D)  REUSE COMPILER

Question 5

If a dependent object is flagged as INVALID, this means that the program unit should be ____________________________.

Accepted Answer

The answer of If a dependent object is flagged as...

Question 6

When a program unit refers to other database objects, the program unit is considered dependent on that object.

Accepted Answer

A) True 
 B)False

Question 7

The ____________________________ data dictionary view allows users to review object status and referenced objects.

Accepted Answer

The answer of The ____________________________ data dictionary view allows users...

Question 8

What is the purpose of the %TYPE and %ROWTYPE attributes?

Accepted Answer

Oracle documentation suggests several te

Question 9

Three classes of compiler warnings exist: info, performance and critical.

Accepted Answer

A) True 
 B)False

Question 10

The ____________________________ is a mechanism available in the Oracle system to provide a map to visualize both direct and indirect dependencies within the database.

Accepted Answer

dependency

Question 11

What can be used to conditionally raise a compile error and associate a custome error number with the error?

Accepted Answer

A)  Selective error 
B)  Selection directive 
C)  Error directive 
D)  Error condition 
A)  Selective error 
B)  Selection directive 
C)  Error directive 
D)  Error condition

Question 12

The ____ is considered the default method of remote dependent objects.

Accepted Answer

A)  signature model 
B)  datestamp model 
C)  timestamp model 
D)  record model 
A)  signature model 
B)  datestamp model 
C)  timestamp model 
D)  record model

Question 13

The dependency tree utility allows the user to review direct and indirect dependencies of an object in either numeric order or indented format.

Accepted Answer

A) True 
 B)False

Question 14

____ shows only direct roles granted to the current schema.

Accepted Answer

A)  SESSION_PRIVS 
B)  SESSION_ROLES 
C)  USER_SYS_PRIVS 
D)  USER_ROLE_PRIVS 
A)  SESSION_PRIVS 
B)  SESSION_ROLES 
C)  USER_SYS_PRIVS 
D)  USER_ROLE_PRIVS

Question 15

Compiler directives are instructions used at run time.

Accepted Answer

A) True 
 B)False

Question 16

The ____ view can be used to review the source code of a procedure, function, or package.

Accepted Answer

A)  USER_SOURCE 
B)  USER_OBJECT 
C)  USER_REVIEW 
D)  USER_DEPENDENCY 
A)  USER_SOURCE 
B)  USER_OBJECT 
C)  USER_REVIEW 
D)  USER_DEPENDENCY

Question 17

Which item below is the name for an IF THEN structure used to accomplish conditional compilation?

Accepted Answer

A)  Selection instruction 
B)  Selection directive 
C)  Selective statement 
D)  Selective option 
A)  Selection instruction 
B)  Selection directive 
C)  Selective statement 
D)  Selective option

Question 18

____ can be used to manually recompile invalid program units.

Accepted Answer

A)  COMPILE 
B)  ALTER RECOMPILE 
C)  ALTER COMPILE 
D)  RECOMPILE 
A)  COMPILE 
B)  ALTER RECOMPILE 
C)  ALTER COMPILE 
D)  RECOMPILE

Question 19

Discuss two situations in which parameter modifications are not viewed as signature modifications and, therefore, do not prompt recompilation.

Accepted Answer

First, if an IN parameter has a default

Question 20

The term ____________________________ refers to connections to other Oracle
database servers.

Accepted Answer

The answer of The term ____________________________ refers to connections to...

Which of the following statements is True?

A program unit is said to contain ____ when it includes references to database objects that in turn references other database objects.

The %TYPE declaration instructs the system to assign the variable data type based on the underlying table column data type at runtime. _________________________

Which compile statement option forces a program unit to retain the compilation settings from the previous compile action?

If a dependent object is flagged as INVALID, this means that the program unit should be ____________________________.

When a program unit refers to other database objects, the program unit is considered dependent on that object.

The ____________________________ data dictionary view allows users to review object status and referenced objects.

What is the purpose of the %TYPE and %ROWTYPE attributes?

Three classes of compiler warnings exist: info, performance and critical.

The ____________________________ is a mechanism available in the Oracle system to provide a map to visualize both direct and indirect dependencies within the database.

What can be used to conditionally raise a compile error and associate a custome error number with the error?

The ____ is considered the default method of remote dependent objects.

The dependency tree utility allows the user to review direct and indirect dependencies of an object in either numeric order or indented format.

____ shows only direct roles granted to the current schema.

Compiler directives are instructions used at run time.

The ____ view can be used to review the source code of a procedure, function, or package.

Which item below is the name for an IF THEN structure used to accomplish conditional compilation?

____ can be used to manually recompile invalid program units.

Discuss two situations in which parameter modifications are not viewed as signature modifications and, therefore, do not prompt recompilation.

The term ____________________________ refers to connections to other Oracle database servers.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Database Triggers

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

Filters

Exam 8: Program Unit Dependencies

Which of the following statements is True?

A program unit is said to contain ____ when it includes references to database objects that in turn references other database objects.

The %TYPE declaration instructs the system to assign the variable data type based on the underlying table column data type at runtime. _________________________

Which compile statement option forces a program unit to retain the compilation settings from the previous compile action?

If a dependent object is flagged as INVALID, this means that the program unit should be ____________________________.

When a program unit refers to other database objects, the program unit is considered dependent on that object.

The ____________________________ data dictionary view allows users to review object status and referenced objects.

What is the purpose of the %TYPE and %ROWTYPE attributes?

Three classes of compiler warnings exist: info, performance and critical.

The ____________________________ is a mechanism available in the Oracle system to provide a map to visualize both direct and indirect dependencies within the database.

What can be used to conditionally raise a compile error and associate a custome error number with the error?

The ____ is considered the default method of remote dependent objects.

The dependency tree utility allows the user to review direct and indirect dependencies of an object in either numeric order or indented format.

____ shows only direct roles granted to the current schema.

Compiler directives are instructions used at run time.

The ____ view can be used to review the source code of a procedure, function, or package.

Which item below is the name for an IF THEN structure used to accomplish conditional compilation?

____ can be used to manually recompile invalid program units.

Discuss two situations in which parameter modifications are not viewed as signature modifications and, therefore, do not prompt recompilation.

The term ____________________________ refers to connections to other Oracle database servers.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Database Triggers

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

Filters