Examine the execution plan:
Which two are true regarding the execution plan?
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |