1Z0-040 Oracle Database 10g: New Features for Administrators Brain Dump

Oracle ™

1Z0-040 Oracle Database 10g: New Features for Administrators

Note 1: 1Z0-040 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 1Z0-040 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 5.

An AFTER SUSPEND system event trigger containing no exception handler is fired, and runs out of space after inserting some audit records. Which two events happen? (Choose two.)

A. The trigger is aborted
B. The trigger is recursively fired
C. The original operation (the one that fired the trigger) continues
D. The original operation (the one that fired the trigger) is aborted

Display Answer

Purchase Full Version:

1Z0-040 Printable PDF Prep Guide $49.95 BUY NOW!

1Z0-040 Test Simulation Engine $69.95 BUY NOW!

1Z0-040 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: A, D Different parallel execution server processes may encounter one or more correctable errors. This may result in firing an AFTER SUSPEND trigger multiple times, in parallel. Also, if a parallel execution server process encounters a non-correctable error while another parallel execution server process is suspended, the suspended statement is immediately aborted. If the user registered a trigger on the AFTER SUSPEND system event, the user trigger is executed. A user supplied PL/SQL procedure can access the error message data using the DBMS_RESUMABLE package and the DBA_ or USER_RESUMABLE view. REF. : Oracle(r) 10g Administrator Guide, 14-9 and 14-10

Explanation: