1Z0-062 Question #49: Real Exam Question with Answer & Explanation

The correct answer is A: LOG_BUFFER. Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization / The log buffer / The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE / Nonstandard block size buffer caches DB_nK_CACHE_SIZE In addition to setting SGA_TARGET to a nonz

Question

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?

Exhibit

Options

ALOG_BUFFER
BSORT_AREA_SIZE
CJAVA_POOL_SIZE
DSTREAMS_POOL_SIZE
EDB_16K_CACHE_SZIE
FDB_KEEP_CACHE_SIZE

Explanation

Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization / The log buffer / The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE / Nonstandard block size buffer caches DB_nK_CACHE_SIZE * In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA * Table, Automatically Sized SGA Components and Corresponding Parameters

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice