What is likely to happen if one of her source tables includes LOB data?

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?

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?

A.
The Extract will revert to single-row fetch mode, and then resume array fetches
afterwards.

B.
The Extract will revert to single-row fetch mode for all tables.

C.
The Extract will abend unless LOBMEMORY is increased.

D.
The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Explanation:

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

S De

S De

Ans: A

Explanation:
If the table contains LOB data, Extract reverts to single-row fetch mode, and then resumes batch fetch mode afterward.

Reply