Oracle
1Z0-054 · Question #83
View the Exhibit and analyze the content of V$BUFFER_POOL_STATISTICS. Why does the query on the EMP table not access buffers from the keep pool?
The correct answer is D. because the blocks of the EMP table are already available in one of the other buffer pools. See the full explanation below for the reasoning.
Question
View the Exhibit and analyze the content of V$BUFFER_POOL_STATISTICS. Why does the query on the EMP table not access buffers from the keep pool?
Exhibit
Options
- Abecause the query used SCOTT.EMP instead of EMP
- Bbecause the query with * always uses the default pool
- Cbecause the query with * always forces physical I/Os that bypass the keep pool
- Dbecause the blocks of the EMP table are already available in one of the other buffer pools
How the community answered
(42 responses)- A14% (6)
- B2% (1)
- C7% (3)
- D76% (32)
Community Discussion
No community discussion yet for this question.