1Z0-060 Question #208: Real Exam Question with Answer & Explanation

Question

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.

Explanation

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.

Common mistakes.

• A. 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.
• D. 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

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loader-express-mode.html

No community discussion yet for this question.