Deck 8: Program Unit Dependencies

Question 1

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

Answer 1

True

Question 2

If granted appropriate rights, it is possible to call database objects from other schemas.

Answer 2

True

Question 3

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

Answer 3

False
is not
isn't

Question 4

The USER_DEPENDENCIES data dictionary view provides information on direct object dependencies.

Question 5

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

Question 6

Compiler directives are instructions used at run time.

Question 7

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

Question 8

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

Question 9

Remote database connections are used to link to another database and to call objects that exist on that database.

Question 10

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

Question 11

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

Question 12

The signature model cannot resolve the time issues of using the timestamp model.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

You can use the USER_OBJECT data dictionary view to review the source code of a procedure, function, or package.

Question 19

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

Question 20

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

Question 21

Which of the following statements is correct?

A) Data dictionaries are used to track remote dependencies.
B) Remote dependencies are checked at compile time.
C) Data dictionaries do not track remote dependencies.
D) If an object on one database is changed, any remote program units that use or depend on that object is immediately changed to an INVALID status.

Question 22

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

A) CREATE PROCEDURE
B) CREATE ANY PROCEDURE
C) DROP ANY PROCEDURE
D) ALTER ANY PROCEDURE

Question 23

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

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

Question 24

The ____ system privilege allows users to create, modify, and drop program units within their own schema.

A) CREATE ANY PROCEDURE
B) ALTER ANY PROCEDURE
C) CREATE PROCEDURE
D) DROP ANY PROCEDURE

Question 25

Only modifications to the ____ can raise the INVALID status of dependent objects.

A) reference objects
B) package specification
C) package body
D) package dependencies

Question 26

The SELECT * statement should be used when querying data from the database rather than a named column list. _________________________

Question 27

Which of the following commands correctly modifies Scott's rights on the bb_basket table?

A) GRANT SELECT, INSERT, UPDATE bb_basket TO scott;
B) GRANT SELECT, INSERT, ON bb_basket TO scott
C) GRANT SELECT, INSERT, UPDATE ON bb_basket;
D) GRANT SELECT, INSERT, UPDATE ON bb_basket TO scott;

Question 28

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

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

Question 29

If a dependent object has an older ____ than the referenced object when called, the dependent object is flagged as INVALID and needs to be recompiled.

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

Question 30

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

A) %SELECT
B) %ROWTYPE
C) %INSERT
D) %DATATYPE

Question 31

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

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

Question 32

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

A) CREATE PROCEDURE
B) CREATE ANY PROCEDURE
C) ALTER PROCEDURE
D) EXECUTE ANY PROCEDURE

Question 33

____ can be used to check the status of database objects.

A) USER_OBJECTS
B) USER_REFERENCE
C) USER_CHECK
D) USER_SOURCE

Question 34

The utldtree.sql file is provided by Oracle and is run to set up the necessary tables, views, and procedures to use the dependency tree. _________________________

Question 35

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

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

Question 36

____ shows only direct roles granted to the current schema.

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

Question 37

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

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

Question 38

____ can be used to manually recompile invalid program units.

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

Question 39

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

A) datestamp
B) signature
C) timestamp
D) recordstamp

Question 40

The data dictionary contains information regarding ____.

A) timestamp information
B) signatures
C) datestamp information
D) user privileges

Question 41

Which of the following statements is True?

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 42

Only modifications to the package specification or the program unit header section can raise the ____________________________ status of dependent objects.

Question 43

The ____________________________ compares the last modification date and time of objects to determine if invalidation occurs.

Question 44

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

Question 45

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.

Question 46

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

Question 47

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

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

Question 48

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

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

Question 49

Which of the following compiler parameter will determine the code optimization techniques used?

A) PLSQL_OPTIMIZE_LEVEL
B) PLSQL_OPTIMIZER
C) PLSQL_CODE_TYPE
D) PLSQL_CCFLAGS

Question 50

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

Question 51

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

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

Question 52

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

Question 53

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

Question 54

What is the difference between the timestamp model and the signature model?

Question 55

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

Question 56

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

A) USER_DEPENDENCY
B) DEPTREE_FILL
C) DEPTREE
D) DEPTREE.FILL

Question 57

Which of the following data dictionarty view can verify compiler parameter settings for an object?

A) PARAMETER_SETTINGS
B) PLSQL_OBJECT_SETTINGS
C) USER_OBJECT_SETTINGS
D) USER_PLSQL_OBJECT_SETTINGS

Question 58

Compiler ____________________________ are settings that affect code optimization and availability of warning messages.

Question 59

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

Question 60

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

Question 61

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