Oracle Database 12c: Installation and Administration — Question 134

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? (Choose two.)

Answer options

• 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.

Correct answer: A, D

Explanation

Statement A is correct because the ALTER SESSION ENABLE RESUMABLE command must be executed to allow resumable operations in that session. Statement D is also correct as a suspended statement will generate an error if corrective actions are not taken during the specified timeout. The other options are incorrect for various reasons: B is wrong because DML operations can be part of PL/SQL blocks and still be resumable; C is incorrect as a resumable statement can be suspended and resumed multiple times; E is false because suspending a statement does not automatically release transaction resources.