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

Oracle认证考试

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

You updated the resource plan directive for the resource consumer group, DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement:   SQL>EXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE  (PLAN => ’DSS_PLAN’,   GROUP_OR_SUBPLAN => ’DSS_USERS’,   NEW_CPU_P1 => 80,   NEW_SWITCH_GROUP => ’CANCEL_SQL’,   NEW_SWITCH_ESTIMATE => TRUE,   NEW_SWITCH_TIME => 600); A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds?()  

  • A、 The session is killed before starting the operation.
  • B、 The session generates an error before starting the operation.
  • C、 The session switches to the CANCEL_SQL resource consumer group before starting the operation.
  • D、 The session hangs before starting the operation.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题