Oracle
1Z0-117 · Question #29
1Z0-117 Question #29: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.