Prev Question
Next Question

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

Prev Question
Next Question

Leave a Reply

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