ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

122 / 155

Question 122:

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.