Auto DOP is enabled for your instance. You execute the following statements: Which three are true about the execution of the join?

The correct answer is B. Hinted DOP is used to calculate statement DOP. C. The EMPLOYEES table is accessed in parallel. E. The hint operates at the level of each table accessed by the statement. C: As per ALTER TABLE employees PARALLEL 2; not D: As per ALTER TABLE departments NOPARALLEL;

Understanding and Influencing the Optimizer

Question

Auto DOP is enabled for your instance. You execute the following statements:

Which three are true about the execution of the join?

Exhibit

Options

ADictionary DOP is used to calculate statements DOP.
BHinted DOP is used to calculate statement DOP.
CThe EMPLOYEES table is accessed in parallel.
DThe DEPARTMENTS table is accessed in parallel.
EThe hint operates at the level of each table accessed by the statement.

How the community answered

(68 responses)

A
4% (3)
B
84% (57)
D
12% (8)

Explanation

C: As per ALTER TABLE employees PARALLEL 2; not D: As per ALTER TABLE departments NOPARALLEL;

Topics

#Auto DOP#parallel hints#degree of parallelism#table-level DOP

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice