可学答题网 > 问答 > OCP 11G认证考试题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You have enabled resumable space alloc


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.
参考答案
参考解析:
分类:OCP 11G认证考试题库