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.
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581
A and d
A and D are the correct answers.
A – The ALTER SESSION ENABLE RESUMABLE statement is issued in the session before the statement executes when the RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.
NOT B – INSERT, UPDATE, and DELETE statements are candidates. The interface used to execute them does not matter; it can be OCI, PL/SQL, or another interface. Also, INSERT INTO…SELECT from external tables can be resumable.
NOT C – resumable statement can be suspended and resumed multiple times during execution.
D – A resumable statement that is suspended for the timeout interval wakes up and returns the exception to the user if the error condition is not resolved within the timeout interval.
NOT E – Suspending a statement automatically results in suspending the transaction. Thus all transactional resources are held through a statement suspend and resume.
The answer should be A,E.
I think A&D
AD
Why CE, not DE?