043 28题

QUESTION 28
You enabled Automatic Shared Memory Management. The initialization parameters are set as
shown below:
SGA_TARGET= 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A maximum of 3 GB can be allocated to shared pool.
B. The value for SGA_TARGET can be increased up to a maximum of 15 GB.
C. A total of 14 GB memory will be allocated to the automatically tuned memory components.
D. Increasing the value for SGA_TARGET will automatically increase the memory allocated for
STREAMS_POOL_SIZE.
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory
allocated to autotuned parameters.
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated
to shared pool from 3 GB to 2 GB.
Answer: B, E
b似乎有问题，sga-max-size=14g，不能超过，如果用scope=spfile，那也可以是16或17...

ce

c严格讲也不对，因为14G是所有sga components的，不全是automatically tuned memory components
但这儿
没法说，
题库中同样的题目和选项，答案都能不一样

这题可能是题库有问题，我在另一个版本的题库中看到的是SGA_MAX_SIZE = 15GB

172题和此题相同，b中为14GB
可能是题目错了