Oracle
1Z0-062 · Question #32
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the tabl
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #32. The question stem and answer options stay visible for context.
Managing the Database Instance
Question
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?
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-
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Buffer cache#KEEP buffer pool#Memory management#OLTP performance