Oracle
1Z0-117 · Question #47
1Z0-117 Question #47: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #47. The question stem and answer options stay visible for context.
Question
Which three statements are true about the usage of optimizer hints?
Options
- AWhenever a query uses table aliases, the hints in the query must use the aliases.
- BThe OPTIMIZER_FEATURES_ENABLE parameter must be set to a version supports the hints used.
- CThe optimizer uses the execution plan with lower cost even if a hint is specified.
- DA schema name for the table must be used in the hint if the table us qualified in the FROM clause.
- EHints can be used to override the optimization approach specified with the OPTIMIZER_MODE parameter.
- FA statement block can have only one hint, and that hint must be immediately after SELECT, UPDATE,
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.