Oracle Exam 1Z0-064 Topic 7 Question 21 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 21
Topic #: 7

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.)

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 performed.

CA low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve performance.

DA high hit ratio may indicate that repeated scanning of the same large table or index is being performed.

EA low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object accessed in the buffer cache.

Show Suggested Answer

Suggested Answer: C, E

by Jolanda at May 04, 2022, 08:59 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!