Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?

The correct answer is A. The DEGREE_OF_PARALLELISMparameter is set to AUTO. C. If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory. https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-8BF3- 2312893A67D7.htm#SUTIL3951

Moving Data

Question

Options

AThe DEGREE_OF_PARALLELISMparameter is set to AUTO.
BYou cannot have multiple SQL *Loader data files.
CIf no data file is specified, it assumes the data file to be <table-name>.dat in the current directory
DYou can have multiple bad files created when loading inparallel.
EYou can selectively load rows into a table based on a filer.

How the community answered

(47 responses)

A
91% (43)
B
2% (1)
D
2% (1)
E
4% (2)

Explanation

https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-8BF3- 2312893A67D7.htm#SUTIL3951

Topics

#SQL*Loader#data loading#express mode

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice