nerdexam
Oracle

1Z0-052 · Question #170

Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

The correct answer is A. You can load data into multiple tables during the same load session B. You can load data from multiple files to a table during the same load session. SQL*Loader supports flexible loading scenarios including loading data into multiple tables and from multiple input files within a single load session.

Moving Data

Question

Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

Options

  • AYou can load data into multiple tables during the same load session
  • BYou can load data from multiple files to a table during the same load session
  • CYou cannot perform selective data loading based on the values available in the records
  • DYou can use an export file generated by the EXPDP utility as an input data file to load the data
  • EYou can load data only if the input file is available on the disk and tape but not a named pipes

How the community answered

(19 responses)
  • A
    95% (18)
  • C
    5% (1)

Why each option

SQL*Loader supports flexible loading scenarios including loading data into multiple tables and from multiple input files within a single load session.

AYou can load data into multiple tables during the same load sessionCorrect

SQL*Loader allows a single control file to define multiple INTO TABLE clauses, enabling data to be loaded into several different tables during one load session.

BYou can load data from multiple files to a table during the same load sessionCorrect

SQL*Loader supports loading from multiple input data files specified in the control file, allowing data spread across several flat files to be loaded into a table in one session.

CYou cannot perform selective data loading based on the values available in the records

This is false - SQL*Loader supports selective data loading using the WHEN clause in the control file, which filters records based on field values before loading.

DYou can use an export file generated by the EXPDP utility as an input data file to load the data

SQL*Loader requires flat text or delimited files as input; it cannot use Data Pump export (.dmp) files, which are a proprietary binary format readable only by the IMPDP utility.

EYou can load data only if the input file is available on the disk and tape but not a named pipes

SQL*Loader can load data from named pipes in addition to disk and tape, making this statement false.

Concept tested: SQL*Loader multi-table and multi-file loading capabilities

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader-concepts.html

Topics

#SQL*Loader#multiple table load#multiple input files#data loading capabilities

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice