033的两道题,请讨论

[复制链接]
查看11 | 回复8 | 2005-10-30 17:05:33 | 显示全部楼层 |阅读模式
1。Which two statements are true of the buffer cache?
A. The buffer pools in Oracle9i can be resized dynamically.
B. The blocks in the buffer cache are managed using one list.
C. The blocks in the buffer cache are managed using two lists.
D. In Oracle9i buffer caches can be dynamically added.
Answer: A, C

2。Which two statements are true of the buffer cache?
A. In Oracle9i, the buffer caches can be individually sized.
B. Blocks in the buffer cache may be in one of several states.
C. In Oracle9i additional buffer caches can be dynamically added.
D. The blocks in the buffer cache are managed using two or more lists, depending on the number of
buffer caches in use.
E. Blocks in the buffer cache may be in one of two states, either free or dirty.
Answer: A, C
1-〉c is not right ,why is 2->Cright. I think 2->answer is A ,B
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
I think that the answer of Q.1 is A and B.anyone agree?
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
1->A,Cbuffer cache have LRUlist and Dirty list
2->A,C is right that I think
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
thanks,Seraphim
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
1。C 和2.D我觉得好象也是对的,db_cache_size,db_keep_cache_size,db_recycle_cache_size都是可以动态修改的。
有没有行家指点一下?
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
怎么没有人关注了?
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
thanks for everyone' discussion,
but i can not have decided which is right yet.
the real difference between "buffer caches can be dynamically added." and "additional buffer caches can be dynamically added" iswhat , i can not understand
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
个人认为1.D也是对的,buffer caches 可以动态增加
2.A是不对的,应该是动态Size buffer pool individual,而不是控制每个cache的size
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
我觉得答案应该是:
1。A,C,D
2.A,B,C
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行