Oracle
1Z0-062 · Question #69
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Managing Performance
Question
A senior DBA asked you to execute the following command to improve performance:
SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?
Options
- AThe keep pool is not configured.
- BAutomatic Workarea Management is not configured.
- CAutomatic Shared Memory Management is not enabled.
- DThe data blocks in the SUBSCRIBE_LOG table are rarely accessed.
- EAll the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
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#BUFFER_POOL recycle#performance tuning#memory management