可学答题网 > 问答 > 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认证考试题库
相关推荐

1、To enable resumable 

To enable resumable space allocation for the instance, which of the following initialization...

2、()is the act of allocating space to co

()is the act of allocating space to containers on board of a container ship in the order of the discharge ports.AContainer loadingBContainer dischargingCStowage planningDContainer checking

3、You want to disable resumable space al

You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?()A 0B 10C 100D NULL

4、You have enabled backup optimization f

You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been b...

5、You have enabled backup optimization

You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:CONFIGURE RETE...

6、You have enabled resumable space alloc

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statemen...