Oracle
1Z0-054 · Question #80
1Z0-054 Question #80: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
Question
You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS and note the top five events. View the Exhibit named TOPSQL and note the problems related to these statements. View the Exhibit named INSTACT and note the table scans. Which two are appropriate solutions to improve performance? (Choose two.)
Options
- AEnable the large pool.
- BKeep the long tables in the keep buffer pool.
- CKeep the short tables in the keep buffer pool.
- DSet the CACHE property on the table for the long tables.
- ESet the CACHE property on the table for the short tables.
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.