nerdexam
Oracle

1Z0-539 · Question #32

1Z0-539 Question #32: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-539 to reveal the answer and full explanation for question #32. The question stem and answer options stay visible for context.

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.

Unlock 1Z0-539 to see the answer

You've previewed enough free 1Z0-539 questions. Unlock 1Z0-539 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-539 Practice