代码改变世界

1Z0-053 争议题目解析212

2016-03-11 15:32  AlfredZhao  阅读(647)  评论(0编辑  收藏  举报

1Z0-053 争议题目解析212

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

题库中原题为:

212.Note the following parameters settings in your database:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issued the following command to increase the value of DB_8K_CACHE_SIZE:
SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
What would happen?
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It will be successful only if the memory is available from the auto tuned components
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_TARGET
D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within
SGA_MAX_SIZE
Answer: D

争议点:
题库答案是D,网上有很多人认为是B。
“标记为正确答案,不看answer版”题库答案是B。

比如LuiseDalian认为是D选项:
http://m.blog.itpub.net/17013648/viewspace-1263977/

比如Riveore认为是D选项:
http://blog.csdn.net/rlhua/article/details/16855799

个人更偏向于B选项,因为模拟实验发现有时是可以成功增加的。

初步结论:
保留争议,暂时遵循B选项。