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
Explanation:
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