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.
ans c,d
Ans – C,E
D – If the resumable_timeout parameter is set at instance there is no need to issue ALTER SESSION statement.
thank you!
D is It was another way to run resumable mode
ANS C,E
E is definitely wrong.
Suspending a statement automatically results in suspending the transaction. Thus all transactional resources are held during a statement suspend and resume.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_RESUMABLE.html#GUID-B954E2B3-6CC0-456B-A275-9ED650613638
Since all other options are wrong, we should choose C and D.