Oracle
1Z0-539 · Question #32
Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?
The correct answer is A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards. See the full explanation below for the reasoning.
Question
Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?
Options
- AThe Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
- BThe Extract will revert to single-row fetch mode for all tables.
- CThe Extract will abend unless LOBMEMORY is increased.
- DThe Extract will perform poorly due to paging unless LOBMEMORY is increased.
How the community answered
(60 responses)- A77% (46)
- B7% (4)
- C3% (2)
- D13% (8)
Community Discussion
No community discussion yet for this question.