Oracle
1Z0-063 · Question #68
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…
The correct answer is A. A resumable statement can be suspended and resumed only once during execution. D. Before a statement executes in resumable mode, the alter session enable resumable statement. See the full explanation below for the reasoning.
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?
Options
- AA resumable statement can be suspended and resumed only once during execution.
- BData Manipulation Language (DML) operations are resumable, provided that they are not
- CA suspended statement will report an error if no corrective action has taken place during a
- DBefore a statement executes in resumable mode, the alter session enable resumable statement
- ESuspending a statement automatically results in suspending a transaction and releasing all the
How the community answered
(30 responses)- A83% (25)
- B3% (1)
- C3% (1)
- E10% (3)
Community Discussion
No community discussion yet for this question.