nerdexam
Oracle

1Z0-062 · Question #157

In which two scenarios do you use SQL* Loader to load data?

The correct answer is C. Load data into multiple tables during the same load statement. D. Generate unique sequential key values in specified columns.. SQL*Loader supports loading into multiple tables within a single load session and can generate unique sequential key values using the SEQUENCE clause in the control file.

Moving Data

Question

In which two scenarios do you use SQL* Loader to load data?

Options

  • ATransform the data while it is being loaded into the database.
  • BUse transparent parallel processing without having to split the external data first.
  • CLoad data into multiple tables during the same load statement.
  • DGenerate unique sequential key values in specified columns.

How the community answered

(21 responses)
  • A
    10% (2)
  • B
    5% (1)
  • C
    86% (18)

Why each option

SQL*Loader supports loading into multiple tables within a single load session and can generate unique sequential key values using the SEQUENCE clause in the control file.

ATransform the data while it is being loaded into the database.

SQL*Loader supports only limited in-line transformation via SQL functions in the control file - complex data transformation during load is better handled by External Tables with full SQL expressions or dedicated ETL tools.

BUse transparent parallel processing without having to split the external data first.

SQL*Loader does not support transparent parallel processing on a single unsplit file - parallel SQL*Loader sessions require the input data to be manually divided into separate files beforehand; External Tables provide more transparent file-level parallelism.

CLoad data into multiple tables during the same load statement.Correct

SQL*Loader's control file syntax allows a single load session to direct records into multiple tables simultaneously using multiple INTO TABLE clauses, each optionally filtered by a WHEN condition.

DGenerate unique sequential key values in specified columns.Correct

SQL*Loader provides a SEQUENCE function in the control file that generates unique, incrementing values for specified columns during load, which is commonly used to populate surrogate primary keys.

Concept tested: SQL*Loader multi-table load and SEQUENCE key generation

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

Topics

#SQL*Loader#data loading#multiple tables#sequential key generation

Community Discussion

No community discussion yet for this question.

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