1Z0-062 · Question #195
Which two statements are true about using SQL*Loader?
The correct answer is A. It can load into multiple tables using the same load statement. B. It can generate unique sequential key values in specified columns.. 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.
How the community answered
(52 responses)- A87% (45)
- C8% (4)
- D2% (1)
- E4% (2)
Why each option
SQL*Loader supports loading into multiple tables in one control file and can generate sequential key values using the SEQUENCE function.
SQL*Loader allows multiple INTO TABLE clauses within a single control file, enabling data to be distributed and loaded into several tables in one operation.
SQL*Loader provides the SEQUENCE function in the control file specification that generates unique, incrementing numeric values for designated columns during the load.
SQL*Loader supports both conventional path loading and direct path loading, so restricting it to direct path only is incorrect.
Because SQL*Loader supports multiple INTO TABLE clauses, it is not limited to loading one table at a time.
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
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader-concepts.html
Topics
Community Discussion
No community discussion yet for this question.