Oracle Database 12c: Installation and Administration — Question 206

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

Answer options

• A. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
• B. You cannot have multiple SQL *Loader data files.
• C. If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory and uses it.
• D. You can have multiple bad files created when loading in parallel.
• E. You can selectively load rows into a table based on a filter.

Correct answer: A, C

Explanation

The correct answers are A and C because in SQL *Loader Express Mode, the DEGREE_OF_PARALLELISM is indeed set to AUTO, and if no data file is provided, it defaults to <table-name>.dat. Options B, D, and E are incorrect because multiple data files are allowed, only one bad file is generated per load by default, and selective loading based on a filter is not a feature of Express Mode.