IBM
C2090-303 · Question #40
Which two statements about using a Load write method in an Oracle Connector stage to tables that have indexes on them are true? (Choose two.)
The correct answer is C. The Load Write method uses the Parallel Direct Path load method. E. Set the environment variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE. See the full explanation below for the reasoning.
Question
Which two statements about using a Load write method in an Oracle Connector stage to tables that have indexes on them are true? (Choose two.)
Options
- ASet the Upsert mode property to "Index".
- BSet the Index mode property to "Bypass".
- CThe Load Write method uses the Parallel Direct Path load method.
- DThe Load Write method uses "Rebuild" mode with no logging automatically.
- ESet the environment variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE,
How the community answered
(30 responses)- A7% (2)
- B17% (5)
- C73% (22)
- D3% (1)
Community Discussion
No community discussion yet for this question.