1Z0-062 · Question #196
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?
The correct answer is A. The DEGREE_OF_PARALLELISM parameter is set to AUTO D. If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory. SQL*Loader Express Mode in Oracle 12c automatically sets parallelism to AUTO and defaults the data file name to the target table name with a .dat extension.
Question
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?
Options
- AThe DEGREE_OF_PARALLELISM parameter is set to AUTO
- BYou cannot load data into multiple tables.
- CYou can selectively load rows into a table based on a filter.
- DIf no data file is specified, it assumes the data file to be <table-name>.dat in the current directory
- EYou cannot have multiple SQL*Loader data files.
How the community answered
(29 responses)- A86% (25)
- B3% (1)
- C3% (1)
- E7% (2)
Why each option
SQL*Loader Express Mode in Oracle 12c automatically sets parallelism to AUTO and defaults the data file name to the target table name with a .dat extension.
In Express Mode, Oracle sets DEGREE_OF_PARALLELISM to AUTO by default, allowing the database engine to determine the optimal number of parallel load streams.
Express Mode does target a single named table, but this is a design characteristic of the mode, not a unique restriction that makes the statement distinctly true - Express Mode is not more restrictive than a standard single-table control file.
Express Mode does not support row filtering via a WHEN clause; selective row loading requires a standard control file.
When no DATA parameter is provided in Express Mode, SQL*Loader automatically looks for a file named <table-name>.dat in the current working directory.
Express Mode does permit specifying multiple input data files using the DATA parameter, so this blanket restriction is false.
Concept tested: SQL*Loader Express Mode defaults and parallelism
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loader-express-mode.html
Topics
Community Discussion
No community discussion yet for this question.