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

Oracle认证考试

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

You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement:   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   (PLAN => ’SALES_PLAN’,   GROUP_OR_SUBPLAN => ’MANAGERS’,   CPU_P1 => 100, CPU_P2 =>0,   SWITCH_GROUP => ’CLERKS’,   SWITCH_TIME_IN_CALL => 600);   A user, SCOTT, who is assigned to the MANAGERS group, starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete?()  

  • A、 The query starts under the CLERKS group and the user, SCOTT, switches back to the MANAGERS group after the query completes.
  • B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
  • C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
  • D、 The query starts under the MANAGERS group, the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes, and then switches back to the MANAGERS group after the query completes.
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题