Oracle
1Z0-054 · Question #76
Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening? (Choose two.)
The correct answer is B. very low buffer cache-hit ratio D. many waits on the db file scattered read event. See the full explanation below for the reasoning.
Question
Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening? (Choose two.)
Options
- Atoo many buffer busy waits
- Bvery low buffer cache-hit ratio
- Cvery high buffer cache-hit ratio
- Dmany waits on the db file scattered read event
How the community answered
(52 responses)- A6% (3)
- B83% (43)
- C12% (6)
Community Discussion
No community discussion yet for this question.