nerdexam
Oracle

1Z0-064 · Question #20

Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)

The correct answer is C. A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve D. A high hit ratio may indicate that repeated scanning of the same large table or index is being. See the full explanation below for the reasoning.

Question

Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)

Options

  • AA high value indicates that the buffer cache is adequately sized for the current workload.
  • BPoor hit ratios indicate that a large number of indexed lookups or small table scans are being
  • CA low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve
  • DA high hit ratio may indicate that repeated scanning of the same large table or index is being
  • EA low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the

How the community answered

(36 responses)
  • A
    14% (5)
  • B
    6% (2)
  • C
    78% (28)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-064 Practice