1Z0-060 · Question #208
Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
The correct answer is B. The DEGREE_OF_PARALLELISM parameter is set to AUTO. C. If no data file is specified, it uses table-name.dat and assumes it is in the current directory. SQL*Loader Express Mode sets DEGREE_OF_PARALLELISM to AUTO by default and uses a data file named after the target table when no file is explicitly specified.
Question
Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
Options
- AYou cannot have multiple SQL*Loader data files.
- BThe DEGREE_OF_PARALLELISM parameter is set to AUTO.
- CIf no data file is specified, it uses table-name.dat and assumes it is in the current directory.
- DA new table is created and data is inserted into the table if it does not exist in a schema.
How the community answered
(36 responses)- A3% (1)
- B89% (32)
- D8% (3)
Why each option
SQL*Loader Express Mode sets DEGREE_OF_PARALLELISM to AUTO by default and uses a data file named after the target table when no file is explicitly specified.
SQL*Loader Express Mode does support multiple input data files; the simplification in Express Mode is the elimination of a separate control file, not a restriction on the number of data files.
In Express Mode, Oracle automatically sets DEGREE_OF_PARALLELISM to AUTO, allowing the database to determine the optimal number of parallel streams based on available CPU and I/O resources without requiring user input.
When no data file parameter is provided in Express Mode, SQL*Loader defaults to looking for a file named <table_name>.dat in the current working directory, simplifying invocation for straightforward load operations.
Express Mode requires the target table to already exist in the schema; it does not automatically create a new table if one is absent, as table definition is the responsibility of the DBA or developer.
Concept tested: SQL*Loader Express Mode defaults for parallelism and file naming
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.