Oracle
1Z0-117 · Question #3
1Z0-117 Question #3: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
Question
Which two types of SQL statements will benefit from dynamic sampling?
Options
- ASQL statements that are executed parallel
- BSQL statement that use a complex predicate expression when extended statistics are not available.
- CSQL statements that are resource-intensive and have the current statistics
- DSQL statements with highly selective filters on column that has missing index statistics
- EShort-running SQL 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.