Exam 8: Program Unit Dependencies

When a program unit includes references to database objects that in turn reference other database objects, it is said to contain direct dependencies.

Only program unit header modifications require a recompilation of dependent objects.

____ allows users to create program units in any schema and does not allow the modification or dropping of program units.

If modifications are made to the code in a package body, the status of dependent objects is changed to INVALID. _________________________

When a procedure is compiled, it stores the datestamp of any referenced objects. _________________________

Compiler variables are used to enable compiler warning messages and conditional compilation.

A(n) ____________________________ occurs when one database object directly references other objects.

When you have successfully saved or compiled a procedure, the status is marked as VALID. _________________________

The PLSQL_CCFLAGS parameter allows using onject-level flags in conditional compilation.

The timestamp model is not the default method and, if desired, needs to be set in the system using one of several commands available.

Oracle offers two models or methods to determine invalidation of remote dependent objects at runtime: timestamp and ____________________________.

The ____ procedure is used to populate the dependency data for the object of interest.

The ____________________________ data dictionary view reveals all the privileges of the current schema.

A column named TIMESTAMP is maintained in the data dictionary and is included in the USER_DEPENDENCIES view.

When a procedure is compiled, it stores the ____ of any referenced objects.

____ instructs the system to assign the variable data type based on the underlying table column data type at runtime.

____ allows a user to modify program units in any schema.

Which of the following is used by Oracle to determine invalidation of remote dependent objects at runtime?

The ____ view shows only the direct privileges of the current schema.

The ____________________________ compares the mode, data type, and the order of parameters and the RETURN data type (for functions) when a remote object call is accomplished in order to determine invalidation.