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? ()
- 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. (Out of space condition Maximum extents reached condition,Space quota exceeded condition)
- 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.
正确答案:A,C,E
答案解析:有
微信扫一扫手机做题