Oracle
1Z0-117 · Question #73
1Z0-117 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
Which two statements are true about the use of the DYNAMIC_SAMPLING hint in a query?
Options
- AIt estimates selectivity better for the filters.
- BIt is always used for flashback queries that contain the AS OF clause.
- CIt cannot be used if there is a single-table predicate in the WHERE clause.
- DIt cannot be used for processing SQL statements in parallel.
- EIt can compensate for the lack of extended statistics to get accurate cardinality estimates for complex
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.