Oracle
1Z0-117 · Question #101
1Z0-117 Question #101: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #101. The question stem and answer options stay visible for context.
Question
You plan to bulk load data INSERT INTO . . . SELECT FROM statements. Which two situations benefit from parallel INSERT operations on tables that have no materialized views defined on them?
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 rows and a
- CDirect path insert of 10 rows into a partitioned, index-organized table containing one million rows and
- DDirect path insert of 10 rows into a partitioned, index-organized table containing 10 rows and a bitmapped
- EConventional path insert of a million rows into a nonpartitioned, heap-organized containing 10 rows
- FConventional path insert of 10 rows into a nonpartitioned, heap-organized table one million rows and
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.