1Z0-062 · Question #32
1Z0-062 Question #32: Real Exam Question with Answer & Explanation
The correct answer is A: Configure the KEEP buffer pool and alter the table with the corresponding storage clause.. Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer pools enable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to pr
Question
Options
- AConfigure the KEEP buffer pool and alter the table with the corresponding storage clause.
- BIncrease the database buffer cache size.
- CConfigure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
- DConfigure Automata Shared Memory Management.
- EConfigure Automatic Memory Management-
Explanation
Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer pools enable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.
Community Discussion
No community discussion yet for this question.