Which three statements about resumable space allocation…

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT
parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT
parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)

A.
Even with resumable space allocation enabled for your database, you can disable resumable space
allocation for a single session.

B.
A resumable statement is suspended only if an out of space error occurs.

C.
When a resumable statement is suspended, the transaction that contains the statement is also suspended.

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

E.
You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are
suspended for a session.



Leave a Reply 0

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