1Z0-062 · Question #384
Which three are true about the default database buffer cache? (Choose three.)
The correct answer is B. It is in the fixed area of the SGA. F. The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer G. Its buffers can contain data block images for blocks that have no corresponding image in a data. The default database buffer cache is a dynamic SGA component that stores copies of data blocks, and it works in conjunction with specialized buffer pools while being able to hold modified blocks not yet written to disk.
Question
Which three are true about the default database buffer cache? (Choose three.)
Options
- ABuffers containing block images may be selected for reuse based only on a Least Recently Used
- BIt is in the fixed area of the SGA.
- CIts buffers can contain data block images for blocks that have a corresponding image in a data
- DBuffers containing block images may be selected for reuse based only on a touch count algorithm.
- EIt can contain block images only for database blocks whose block size is equal to the buffer size.
- FThe keep and recycle cache memory is sub-allocated from memory allocated to the default buffer
- GIts buffers can contain data block images for blocks that have no corresponding image in a data
How the community answered
(48 responses)- A2% (1)
- B73% (35)
- C6% (3)
- D4% (2)
- E15% (7)
Why each option
The default database buffer cache is a dynamic SGA component that stores copies of data blocks, and it works in conjunction with specialized buffer pools while being able to hold modified blocks not yet written to disk.
Oracle uses an enhanced Least Recently Used (LRU) algorithm for buffer reuse, which considers factors beyond simple recency, not based solely on LRU.
The database buffer cache is a primary and essential component within the System Global Area (SGA), which is allocated as a contiguous and relatively fixed block of memory at instance startup.
Oracle's buffer replacement algorithm is an enhanced LRU, not solely a touch count algorithm, as it considers multiple factors for buffer reuse.
The default buffer cache primarily stores blocks corresponding to the `DB_BLOCK_SIZE`; blocks from tablespaces with non-default block sizes reside in their specific `DB_nK_CACHE` pools.
While configured separately, the `KEEP` and `RECYCLE` buffer pools functionally manage subsets of blocks that would otherwise reside in the default buffer cache, representing specialized management strategies within the overall buffer memory.
When a data block is modified in the buffer cache, its in-memory 'dirty' image is different from the image currently on disk, meaning the specific buffer image does not yet have an exact corresponding image in the data file until it is written.
Concept tested: Oracle Database Buffer Cache architecture and management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/concept/physical-storage-structure.html
Topics
Community Discussion
No community discussion yet for this question.