Oracle
1Z0-062 · Question #112
1Z0-062 Question #112: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #112. The question stem and answer options stay visible for context.
Question
Which three statements are true about SQL plan directives?
Options
- AThey are tied to a specific statement or SQL ID.
- BThey instruct the maintenance job to collect missing statistics or perform dynamic sampling to
- CThey are used to gather only missing statistics.
- DThey are created for a query expression where statistics are missing or the cardinality estimates
- EThey instruct the optimizer to create only column group statistics.
- FImprove plan accuracy by persisting both compilation and execution statistics in the SYSAUX
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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.