nerdexam
Oracle

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.

Exploring the Oracle Database Architecture

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)
  • A
    2% (1)
  • B
    73% (35)
  • C
    6% (3)
  • D
    4% (2)
  • E
    15% (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.

ABuffers containing block images may be selected for reuse based only on a Least Recently Used

Oracle uses an enhanced Least Recently Used (LRU) algorithm for buffer reuse, which considers factors beyond simple recency, not based solely on LRU.

BIt is in the fixed area of the SGA.Correct

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.

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.

Oracle's buffer replacement algorithm is an enhanced LRU, not solely a touch count algorithm, as it considers multiple factors for buffer reuse.

EIt can contain block images only for database blocks whose block size is equal to the buffer size.

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.

FThe keep and recycle cache memory is sub-allocated from memory allocated to the default bufferCorrect

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.

GIts buffers can contain data block images for blocks that have no corresponding image in a dataCorrect

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

#SGA#database buffer cache#memory management#block images

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice