代码改变世界

1Z0-053 争议题目解析481

2016-03-25 14:28  AlfredZhao  阅读(682)  评论(0编辑  收藏  举报

1Z0-053 争议题目解析481

考试科目:1Z0-053
题库版本:V13.02

题库中原题为:

481.Which statement is true about a running session that belongs to the online transaction processing
(OLTP) group?

A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests
or 2,500 MB of data transfer.
B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer
group, and then switches to the original group.
C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500
MB of data transfer and returns to the original group after the operation.
D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500
MB of data transfer for queries, but not for data manipulation language (DML) operations.
Answer: D
争议点:
网上有人说选择C,比如“标记为正确答案,不看answer版”题库。

比如:
Riveore的解析:http://blog.csdn.net/rlhua/article/details/20449261

LuiseDalian的解析:http://blog.itpub.net/17013648/viewspace-1305117/

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE
switch_for_call,决定是否执行一个操作,因为switch_time, switch_io_megabytes, 或switch_io_reqs参数,
在顶级调用结束之后consumer group是否还原到原来的consumer group.

初步结论:
选择C。