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 and D.
Refer: http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm
D is not extrictly necessary because the initialization parameter resumable_timeout is set…
A statement executes in a resumable mode only if its session has been enabled for resumable space allocation by one of the following actions:
The RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.
The ALTER SESSION ENABLE RESUMABLE statement is issued.
But since all other options are wrong we should go with C and D
Thanks Vonpire!
Yes D is not necessary
Answers C and D are fine,
quotation from 12.1 documentation
“A statement executes in resumable mode only if its session has been enabled for resumable space allocation by one of the following actions:
– The ALTER SESSION ENABLE RESUMABLE statement is issued in the session before the statement executes when the RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.
– The ALTER SESSION ENABLE RESUMABLE TIMEOUT timeout_value statement is issued in the session before the statement executes, and the timeout_value is a nonzero value.”
So it is always needed to enabled resumable for the session, resumable_timeout parameter changes only the requied syntax of alter session statement.
CD
CD
All are wrong…. :-((((
A is wrong:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm
“8. A resumable statement can be suspended and resumed multiple times during execution.”
B is wrong:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm
“DML
INSERT, UPDATE, and DELETE statements are candidates. The interface used to execute them does not matter; it can be OCI, SQLJ, PL/SQL, or another interface. Also, INSERT INTO…SELECT from external tables can be resumable.”
C is worng:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm
“When a resumable statement is suspended, the error is not raised to the client. In order for corrective action to be taken, Oracle Database provides alternative methods for notifying users of the error and for providing information about the circumstances.”
D is wrong:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm
“A statement executes in a resumable mode only if its session has been enabled for resumable space allocation by one of the following actions:
– The RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.
– The ALTER SESSION ENABLE RESUMABLE statement is issued.”
E is wrong:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm
“Suspending a statement automatically results in suspending the transaction. Thus all transactional resources are held through a statement suspend and resume.”
BIG-G, Do not induce wrong answer if you do not know or read before you post
The correct answer are C and D
C.
A suspended statement will report an error if no corrective action has taken place during a
timeout period.
On : OCA: Oracle Database 12c Administrator Certified Associate Study Guide pag 561 at the bottom
link to page : https://books.google.ro/books?id=HwOCAwAAQBAJ&pg=PA561&lpg=PA561&dq=if+no+corrective+action+has+taken+place+during+timeout+period&source=bl&ots=deb0PKv6LU&sig=p21buVpEtGbfK4gc0TxWboZmxGk&hl=en&sa=X&ved=0ahUKEwjhhPymstTLAhVpJJoKHa7JB3oQ6AEIMDAE#v=onepage&q=if%20no%20corrective%20action%20has%20taken%20place%20during%20timeout%20period&f=false
and for answer D :
A statement executes in a resumable mode only if its session has been enabled for resumable space allocation by one of the following actions:
The RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.
The ALTER SESSION ENABLE RESUMABLE statement is issued.
link : https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm at line : How Resumable Space Allocation Works
CD
https://docs.oracle.com/cd/E57425_01/121/ADMIN/schema.htm#i1007794
CD