Oracle
1Z0-064 · Question #36
1Z0-064 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Question
Examine the parameters set for your database instance: You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some queries. While diagnosing, you notice a large number of hard parses occurring for several syntactically almost identical SQL statements that differ only in literal values in the WHERE clause. Which two actions would you recommend to improve performance? (Choose two.)
Exhibit
Options
- ACreate the KEEP cache and cache the tables used in the queries.
- BSet the CURSOR_SHARING parameter to FORCE.
- CUse bind variables instead of literals.
- DCreate SQL plan baselines for the almost identical SQL statements and load them into the cursor
- ESet the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.
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.