Oracle
1Z0-054 · Question #82
1Z0-054 Question #82: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Question
You are working in an online transaction processing (OLTP) environment. You received many complaints from users about degraded performance. Your senior DBA asked you to execute the following command to improve the 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 having one million rows. Which factor could be a reason for this recommendation?
Options
- AThe keep pool is not configured.
- BThe automatic Program Global Area (PGA) is not configured.
- CThe CURSOR_SPACE_FOR_TIME initialization parameter is set to FALSE.
- DThe most of the rows in SUBSCRIBE_LOG table are accessed once a week.
- EAll the queries on the SUBSCRIBE_LOG table are rewritten using a materialized view.
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.