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)- A16% (4)
- B8% (2)
- C72% (18)
- E4% (1)
Community Discussion
No community discussion yet for this question.