Unformatted text preview: e executable section after the exception is
handled rather it propagates to the enclosing block.
B. As a rule of thumb, exceptions are declared in the declarative section, raised in the
and handled in the exception-handling section. When an exception is raised, the control is
passed to the
QUESTION 82: Which two tables or views track object dependencies? (Choose two)
Answer: A, C
A. The data dictionary view USER_DEPENDENCIES displays information about all
direct dependencies within
Actualtests.com - The Power of Knowing 1Z0-147
C. The IDEPTREE View displays indirect dependencies in an indented format.
B, D & E. These are not valid Oracle Views
QUESTION 83: Examine the trigger heading:
CREATE OR REPLACE TRIGGER salary_check
BEFORE UPDATE OF sal, job ON emp
FOR EACH ROW
Under which condition does this trigger fire?
A. When a row is inserted into the EMP table.
B. When the value of the SAL or JOB column in a row is updated in the EMP table.
C. When any column other than the SAL and JOB columns in a row are updated in the
D. Only when both values of the SAL and JOB columns in a row are updated together in
the EMP table.
The triggering event is based on an UPDATE of the SAL or the JOB column in the EMP
A. The triggering event is not an INSERT into the table.
C. The Trigger is defined to fire when either the SAL or JOB columns are updated. The
trigger will not fire if any of the other columns in the table are updated.
D. The Trigger fires based on an Update of the SAL OR JOB Column . This is not an
QUESTION 84: You have an AFTER UPDATE row-level on the table EMP. The
trigger queries the EMP table and inserts the updating
user's information into the AUDIT_TABLE.
What happens when the user updates rows on the EMP table?
A. A compile time error occurs.
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09