Examine the execution plan: Which two are true regarding the execution plan?

The correct answer is B. The SALES table is hash partitioned. C. The CUSTOMERS table is scanned first and selected partitions from the SALES table are scanned. B: As per line 14 and 15. C: As per exhibit line 13 is execute before line 15. Not E: As per line 13 and 15 ?they are not executed simultaneously.

Understanding and Influencing the Optimizer

Question

Examine the execution plan:

Which two are true regarding the execution plan?

Exhibits

Options

AThe CUSTOMERS table is hash partitioned.
BThe SALES table is hash partitioned.
CThe CUSTOMERS table is scanned first and selected partitions from the SALES table are scanned
DThe SALES table is scanned first and selected partitions from the CUSTOMERS table are scanned
EBoth the CUSTOMERS and SALES tables are scanned simultaneously and rows from the CUSTOMERS
FThe CUSTOMERS table is range partitioned.

How the community answered

(37 responses)

A
3% (1)
B
84% (31)
D
8% (3)
E
5% (2)

Explanation

B: As per line 14 and 15. C: As per exhibit line 13 is execute before line 15. Not E: As per line 13 and 15 ?they are not executed simultaneously.

Topics

#hash partitioning#partition pruning#execution plan#partitioned table join

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice