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.