043-OCPThe memory used by Streams will be allocated from the shared pool

194: You have set some of the initialization parameters as:

DB_BLOCK_SIZE = 8KB

SGA_MAX_SIZE = 2GB

SGA_TARGET = 0

SHARED_POOL_SIZE = 120MB

DB_CACHE_SIZE = 896MB

STREAM_POOL_SIZE = 0

LARGE_POOL_SIZE = 110MB

Which two statements are correct? (Choose two.)

A.You cannot set a value for the DB_8K_CACHE_SIZE parameter.
B.The memory used by Streams will be allocated from the shared pool.
C.If you increase the size of large pool to 120 MB, then the memory
allocated to shared pool will be reduced to 110 MB.
D.If an application attempts to allocate more than 120 MB from the
shared pool, and free space is available in the buffer pool, then the free
space from the buffer pool is allocated to the shared pool.

答案：AB

但是翻阅10g官方文档有如下内容：

If SGA_TARGET is set, then the SGA memory for the Streams pool comes from the global pool of SGA. If SGA_TARGET is not set, then SGA for the Streams pool is transferred from the buffer cache. This transfer takes place only after the first use of Streams. The amount transferred is 10% of the shared pool size.

Oracle's Automatic Shared Memory Management feature manages the size of the Streams pool when the SGA_TARGET initialization parameter is set to a nonzero value. If the STREAMS_POOL_SIZE initialization parameter also is set to a nonzero value, then Automatic Shared Memory Management uses this value as a minimum for the Streams pool.

If the STREAMS_POOL_SIZE initialization parameter is set to a nonzero value, and the SGA_TARGET parameter is set to 0 (zero), then the Streams pool size is the value specified by the STREAMS_POOL_SIZE parameter, in bytes.

If both the STREAMS_POOL_SIZE and the SGA_TARGET initialization parameters are set to 0 (zero), then, by default, the first use of Streams in a database transfers an amount of memory equal to 10% of the shared pool from the buffer cache to the Streams pool.

明确说明 当SGA_TARGET=0 并且STREAM_POOL_SIZE=0 的时候，在第一次使用streams的时候从buffer cache 中分配内存。

本题只能选择 A