nerdexam
Oracle

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.

New Features for Manageability

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)
  • A
    3% (1)
  • B
    89% (32)
  • D
    8% (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.

AYou cannot have multiple SQL*Loader data files.

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.

BThe DEGREE_OF_PARALLELISM parameter is set to AUTO.Correct

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.

CIf no data file is specified, it uses table-name.dat and assumes it is in the current directory.Correct

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.

DA new table is created and data is inserted into the table if it does not exist in a schema.

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

#SQL*Loader express mode#parallel loading#data file defaults#Oracle 12c loading

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice