Oracle
1Z0-064 · Question #30
1Z0-064 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Question
You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries. You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar. Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)
Options
- ASet the RESULT_CAHCE_MODE parameter to FORCE for the instance.
- BUse the result cache hint in the queries.
- CUse bind variables for similar queries instead of literals.
- DSet the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.
- EConfigure the KEEP pool and cache the queried tables used in the KEEP pool.
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.