试题详情
- 单项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- Evaluate the set of
- In your
- While performi
- Which three statemen
- Your database&
- While selectin
- A snapshot&ens
- Your multitenant con
- What is true about s
- Evaluate the SQL st
- ViewtheExhibitandexa
- Which command&
- Tape streaming is n
- 假设在数据库中创建了用户test，需要为
- You work
- Which fourQ
- You work
- How can
- In your t
- The ORACLE_SID