---

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？ （）
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

---

出自：Oracle认证

显示答案