Which two statements are true about a buffer cache?

Question

Options

• AWhen a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it
• BA buffer cache stores copies of data blocks from all files of the database.
• CBuffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean
• DA buffer cache always resides completely in System Global Area (SGA).
• EA buffer cache contains exactly three pools: default, keep, and recycle pool.

• A
  70% (33)
• B
  15% (7)
• C
  11% (5)
• D
  4% (2)

Explanation

Multiple Buffer Pools You can configure the database buffer cache with separate buffer pools that either keep data in the buffer cache or make the buffers available for new data immediately after using the data blocks. Particular schema objects (tables, clusters, indexes, and partitions) can then be assigned to the appropriate buffer pool to control the way their data blocks age out of the cache. - The KEEP buffer pool retains the schema object's data blocks in memory. - The RECYCLE buffer pool eliminates data blocks from memory as soon as they are no longer - The DEFAULT buffer pool contains data blocks from schema objects that are not assigned to any buffer pool, as well as schema objects that are explicitly assigned to the DEFAULT pool.

No community discussion yet for this question.