You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.
Which two statements are true?
A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C. A resumable statement can be suspended and resumed only once during execution.
D. A suspended statement will report an error if no corrective action has taken place during a timeout period.
E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
|
Download Printable PDF. VALID exam to help you PASS. |
 |