READ Free Dumps For Oracle- 1z0-117
| Question ID 2625 |
|
| Option A | A. 3, 5, 4, 6, 7 |
| Option B | B. 3, 5, 4, 7, 6 |
| Option C | C. 3, 4, 5, 7, 6 |
| Option D | D. 4, 5, 3, 7, 6 |
| Correct Answer | B |
| Question ID 2626 | Examine the Exhibit. Which two statements are true about the bloom filter in the execution plan? |
| Option A | A. The bloom filter prevents all rows from table T1 that do not join T2 from being needlessly distributed. |
| Option B | B. The bloom filter prevents all rows from table T2 that do not join table T1 from being needlessly |
| Option C | C. The bloom filter prevents some rows from table T2 that do not join table T1 from being needlessly distributed. |
| Option D | D. The bloom filter is created in parallel by the set of parallel execution processes that scanned table T2. |
| Option E | E. The bloom filter is created in parallel by the set of parallel execution processes that later perform join. |
| Option F | F. The bloom filter is created in parallel by the set of parallel execution processes that scanned table T1. |
| Correct Answer | C,E |
