Oracle Database 12c: Advanced Administration — Question 51

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?

Answer options

• A. A resumable statement can be suspended and resumed only once during execution.
• B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
• D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
• E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Correct answer: A, D

Explanation

Option A is correct because resumable statements can only be suspended and resumed one time during their execution. Option D is also correct since the session must be explicitly set to enable resumable statements before executing in that mode. The other options are incorrect as they either misrepresent the resumable behavior or the transactional implications.