请教1Z0-031的一个问题！

显示全部楼层 · 2005-10-30 17:05:33

SG第一章第3题，
Which two of the following statements are true about the Shared Pool?
a) The shared Pool consists of the Liabrary Cache, Data Dictionary Cache, Shared SQL area, Java Pool, and Large Pool
b) The shared Pool is used to store the most recently executed SQL statements and the most recently used data.
c) The shared Pool is used for object that can be shared globally.
d) The Library Cache consists of the Shared Sql and Shared PL/SQL areas.
SG给出的答案是：B and D
最开始的时候我认为B，C，D都是正确的，但是在仔细的看过SG
并分析后，觉得答案应该还是C和D。
因为答案B中，应该是most recently executed SQL statements and most recently used data definition. 在答案B中少了defnition。
我把SG中的原话摘录给大家看看：
针对答案B，书中的原话是这样的：
The shared pool is used to store the most recently executed SQL statements and the most recently used data definition
1) It consists of two .....
2) Sized by ....
摘录于SG 31 page. 这里说的是data definition 而不是data.
但是我有点疑惑的是(当然这个问题是另外一个疑问了)，
在Page 32中有这样的话，
The library cache :
1) Enables the sharing ....
2) Is managed by a least recently used(LRU)
从这里可以看出，Library Cache 用的是LRU算法，但是Data Dictionary Cache 用的是MRU算法。但是SG中又说，Shared Pool用的是MRU算法。好象SG中在这点上的说法是矛盾的。
另外答案C的出处在PG 31中，
Since the shared pool is used for objects that can be shared globally, such as resuable SQL ......
所以，我觉得这道问题的答案是C和D。因为B中说的是DATA，但是SG中说的却是Data definition。而且，根据Shared Pool的构成来看，一个是SQL，另外一个是Data Dictionary，它确实是Definition的东西，而不是DATA本身。
请各位大虾指教！不胜感激！

千问 · 2005-10-30 17:05:33

The newer version of Study Guide has been changed.The answer is B, C and D.
Regards,
Raymond

千问 · 2005-10-30 17:05:33

Do you have the newest version study guide? Would you please send me
a copy or paste it here? Thanks
My email: [email protected]

千问 · 2005-10-30 17:05:33

Actually, I am attending the course, so, I just have the hardcopy.Sorry that I can't email it to you.
I find that the changes are not just the practice, some of the content also been changed.So, I also want to ask, does anyone have the softcopy of the newer version.As I know, the sg of 007, 031 and 032 in ftp are old version.
The new version of 007 is on Oct 2001, 031 is on Sept 2002 and 032 is on Aug 2002.(You can find the version on the first page of each module)
Regards,
Raymond

千问 · 2005-10-30 17:05:33

Yes, my SG is the older version. But, where to find the newer version?
Who are kindness to upload the newer version?
Thanks a lot.

千问 · 2005-10-30 17:05:33

谁有新版的ＳＧ能提供上来啊？不胜感激