Oracle Exam 1Z0-447 Topic 9 Question 55 Discussion

Actual exam question for Oracle's 1Z0-447 exam

Question #: 55
Topic #: 9

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?

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.

Show Suggested Answer

Suggested Answer: A

by Vincenza at Jul 22, 2022, 11:46 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-447 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!