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.
The correct answer are C and D
C.
A suspended statement will report an error if no corrective action has taken place during a
timeout period.
On : OCA: Oracle Database 12c Administrator Certified Associate Study Guide pag 561 at the bottom
link to page : https://books.google.ro/books?id=HwOCAwAAQBAJ&pg=PA561&lpg=PA561&dq=if+no+corrective+action+has+taken+place+during+timeout+period&source=bl&ots=deb0PKv6LU&sig=p21buVpEtGbfK4gc0TxWboZmxGk&hl=en&sa=X&ved=0ahUKEwjhhPymstTLAhVpJJoKHa7JB3oQ6AEIMDAE#v=onepage&q=if%20no%20corrective%20action%20has%20taken%20place%20during%20timeout%20period&f=false
and for answer D :
A statement executes in a resumable mode only if its session has been enabled for resumable space allocation by one of the following actions:
The RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.
The ALTER SESSION ENABLE RESUMABLE statement is issued.
link : https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm at line : How Resumable Space Allocation Works
B E
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#i1006595
AE
A-The RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value. The ALTER SESSION ENABLE RESUMABLE statement is issued.
E-A suspension time out interval is associated with resumable statements. A resumable statement that is suspended for the timeout interval (the default is two hours) wakes up and returns the exception to the user.
B-Suspending a statement automatically results in suspending the transaction. Thus all transactional resources are held through a statement suspend and resume.
C-Never
D-A resumable statement can be suspended and resumed multiple times during execution.