READ Free Dumps For Oracle- 1z0-117
| Question ID 2508 | You plan to bulk load data INSERT INTO . . . SELECT FROM statements. |
| Option A | A. Direct path insert of a million rows into a partitioned, index-organized table containing one million rows and a conventional B*tree secondary index. |
| Option B | B. Direct path insert of a million rows into a partitioned, index-organized table containing 10 rows and a bitmapped secondary index. |
| Option C | C. Direct path insert of 10 rows into a partitioned, index-organized table containing one million rows and conventional B* tree secondary index. |
| Option D | D. Direct path insert of 10 rows into a partitioned, index-organized table containing 10 rows and a bitmapped secondary index |
| Option E | E. Conventional path insert of a million rows into a nonpartitioned, heap-organized containing 10 rows and having a conventional B* tree index. |
| Option F | F. Conventional path insert of 10 rows into a nonpartitioned, heap-organized table one million rows and a bitmapped index. |
| Correct Answer | A,B |
| Question ID 2509 | Which are the two prerequisites for enabling star transformation on queries? |
| Option A | A. The STAR TRANSFORMATION _ENABLED parameter should be set to TRUE or TEMP_DISABLE. |
| Option B | B. A B-tree index should be built on each of the foreign key columns of the fact table(s), |
| Option C | C. A bitmap index should be built on each of the primary key columns of the fact table(s). |
| Option D | D. A bitmap index should be built on each of the foreign key columns of the fact table(s). |
| Option E | E. A bitmap index must exist on all the columns that are used in the filter predicates of the query. |
| Correct Answer | A,E |