1Z0-117 · Question #29
You plan to bulk load data using INSERT /+PARALLEL/ INTO . . . . SELECT FROM statements. Which four types of operations can execute in parallel on tables that have no bitmapped indexes or…
The correct answer is A. Direct path insert of a million rows into a partitioned, index-organized table containing one million rows. B. Direct path insert of a million rows into a partitioned, index-organized table containing 10 million rows. D. Direct path insert of a million rows into a nonpartitioned, heap-organized table containing 10 million rows. E. Direct path insert of a million rows into a nonpartitioned, heap-organized table containing one million rows. Direct-path INSERT is not supported for an index-organized table (IOT) if it is not partitioned, if it has a mapping table, or if it is reference by a materialized view.
Question
You plan to bulk load data using INSERT /+PARALLEL/ INTO . . . . SELECT FROM statements. Which four types of operations can execute in parallel on tables that have no bitmapped indexes or materialized views defined on term?
Options
- ADirect path insert of a million rows into a partitioned, index-organized table containing one million rows.
- BDirect path insert of a million rows into a partitioned, index-organized table containing 10 million rows.
- CDirect path insert of a million rows into a nonpartitioned, index-organized table containing one million rows.
- DDirect path insert of a million rows into a nonpartitioned, heap-organized table containing 10 million rows.
- EDirect path insert of a million rows into a nonpartitioned, heap-organized table containing one million rows.
How the community answered
(29 responses)- A72% (21)
- C28% (8)
Explanation
Direct-path INSERT is not supported for an index-organized table (IOT) if it is not partitioned, if it has a mapping table, or if it is reference by a materialized view.
Topics
Community Discussion
No community discussion yet for this question.