nerdexam
Oracle

1Z0-338 · Question #54

Which two options would you use to allow direct path loads to run in parallel on your Exadata platform? (Choose two.)

The correct answer is C. setting the PARALLEL clause on both the external table and the table where you are loading the data D. adding the PARALLEL hint to the CTAS or IAS statement. See the full explanation below for the reasoning.

Question

Which two options would you use to allow direct path loads to run in parallel on your Exadata platform? (Choose two.)

Options

  • Acreating the required environment by using Smart Scan parallelization
  • Bsetting the initialization parameter PARALLEL_ENABLED to TRUE to enable parallel direct path loads
  • Csetting the PARALLEL clause on both the external table and the table where you are loading the data
  • Dadding the PARALLEL hint to the CTAS or IAS statement
  • Esetting the PARALLEL_FORCE_LOCAL parameter to TRUE

How the community answered

(25 responses)
  • A
    16% (4)
  • B
    8% (2)
  • C
    72% (18)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-338 Practice