Oracle
1Z0-117 · Question #81
1Z0-117 Question #81: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #81. The question stem and answer options stay visible for context.
Question
You are administering a database, where an application frequently executes identical SQL statements with the same syntax. How will you optimize the query results without retrieving data blocks from the storage?
Options
- ABy setting the CURSOR_SHARING parameter to FORCE.
- BBy using the bind variables and setting the CURSOR_SHARING parameter to EXACT.
- CBy using the CACHE hint to pin the queries in the library cache
- DBy ensuring that RESULT_CACHE_MODE parameter is set to MANUAL and using the RESULT_CACHE
- EBy creating a SQL plan baseline for the identical statements.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 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.