Which four types of operations can execute in parallel on tables that have no bitmapped indexes or materialized views defined on term?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *