Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

The answer of Only modifications to the package specification or...

Question 5

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.

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The data dictionary contains information regarding ____.

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The timestamp model compares the last mo

Question 15

Which of the following statements is correct?

Accepted Answer

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

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

Accepted Answer

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

Question 17

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

Accepted Answer

The answer of Compiler ____________________________ are settings that affect code...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

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

Accepted Answer

The answer of The ____________________________ compares the last modification date...

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

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

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

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

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.

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

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

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

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

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

The data dictionary contains information regarding ____.

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

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

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

Which of the following statements is correct?

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

The data dictionary contains information regarding ____.

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

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

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

Which of the following statements is correct?

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

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

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

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

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

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