1Z0-117 Web TestEngine demo

Examine the execution plan:

Which two are true regarding the execution plan?

Select all that apply.

• A

  The CUSTOMERS table is hash partitioned.

• B

  The SALES table is hash partitioned.

• C

  The CUSTOMERS table is scanned first and selected partitions from the SALES table are scanned based on the BLOOM Filter created during the scan of the CUSTOMERS table.

• D

  The SALES table is scanned first and selected partitions from the CUSTOMERS table are scanned based on the Bloom Filter created during the scan of the SALES table.

• E

  Both the CUSTOMERS and SALES tables are scanned simultaneously and rows from the CUSTOMERS table are joined to row of the SALES table.

• F

  The CUSTOMERS table is range partitioned.