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?
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.
C.
Direct path insert of a million rows into a nonpartitioned, index-organized table containing one
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.
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.
A,B,D,E