Prev Question
Next Question

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

Explanation:

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *