Oracle Database 12c: Installation and Administration — Question 246

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?

Answer options

• A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• B. Increase the database buffer cache size.
• C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
• D. Configure Automata Shared Memory Management.
• E. Configure Automatic Memory Management.

Correct answer: A

Explanation

The correct answer is A because configuring the KEEP buffer pool ensures that specific data blocks remain in memory, preventing them from being aged out. Option B may help by providing more space, but it doesn't guarantee the retention of specific blocks. Options C, D, and E do not directly address the requirement to keep specific blocks in the buffer cache.