多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题