You want the 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.
Suspending a statement automatically results in suspending a transaction and releasing
all the resources held by the transaction.
C.
Data Manipulation Language (DML) operations are resumable, provided that they are not
embedded in a PL/SQL block.
D.
A resumable statement can be suspended and resumed only once during execution.
E.
A suspended statement will report an error if no corrective action has taken place during
a timeout period.
Only E is valid
A is valid only if session is aleady running while init parameter changed.
C,D ?