1Z0-062 Question #195: Real Exam Question with Answer & Explanation

The correct answer is A: It can load into multiple tables using the same load statement.. SQL*Loader supports loading into multiple tables in one control file and can generate sequential key values using the SEQUENCE function.

Question

Which two statements are true about using SQL*Loader?

Options

AIt can load into multiple tables using the same load statement.
BIt can generate unique sequential key values in specified columns.
CIt can load data from external files by using the direct path only.
DIt can load data into one table at a time.
EIt can load data from external files by using the conventional path only.

Explanation

SQL*Loader supports loading into multiple tables in one control file and can generate sequential key values using the SEQUENCE function.

Common mistakes.

C. SQL*Loader supports both conventional path loading and direct path loading, so restricting it to direct path only is incorrect.
D. Because SQL*Loader supports multiple INTO TABLE clauses, it is not limited to loading one table at a time.
E. SQL*Loader supports both conventional path and direct path loading methods, not conventional path only.

Concept tested. SQL*Loader multi-table load and SEQUENCE function

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

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice