Which two statements are true?

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?

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.
Before a statement executes in resumable mode, the alter session enable resumable
statement must be issued in its session.

B.
Suspending a statement automatically results in suspending a transaction and releasing
all the resources held by the transaction.

C.
Data Manipulation Language (DML) operations are resumable, provided that they are not
embedded in a PL/SQL block.

D.
A resumable statement can be suspended and resumed only once during execution.

E.
A suspended statement will report an error if no corrective action has taken place during
a timeout period.



Leave a Reply 2

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


Vlad

Vlad

Only E is valid
A is valid only if session is aleady running while init parameter changed.