Oracle
1Z0-117 · Question #121
1Z0-117 Question #121: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #121. The question stem and answer options stay visible for context.
Question
You enable auto degree of parallelism (DOP) for your database instance. Examine the following query: Which two are true about the execution of statement?
Exhibit
Options
- ADictionary DOP for the objects accessed by the query is used to determine the statement DOP.
- BAuto DOP is used to determine the statement DOP only if the estimated serial execution time exceeds
- CDictionary DOP is used to determine the statement DOP only if the estimated serial execution time exceeds
- DThe statement will be queued if insufficient parallel execution slaves are available to satisfy the statements
- EThe statement will be queued if the number of busy parallel execution servers exceeds PARALLEL_
- FThe statements may execute serially.
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.