Exam 1z0-062 topic 1 question 143 discussion

However, in the following situations, use SQL*Loader for the best load performance: - You want to load data remotely. - Transformations are not required on the data, and the data does not need to be loaded in parallel.

(https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm#sthref519) Choosing External Tables Versus SQL*Loader The record parsing of external tables and SQL*Loader is very similar, so normally there is not a major performance difference for the same record format. However, due to the different architecture of external tables and SQL*Loader, there are situations in which one method is more appropriate than the other. In the following situations, use external tables for the best load performance: - You want to transform the data as it is being loaded into the database. - You want to use transparent parallel processing without having to split the external data first. However, in the following situations, use SQL*Loader for the best load performance: - You want to load data remotely. - Transformations are not required on the data, and the data does not need to be loaded in parallel.

C D is correct: https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm

A and B https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm#sthref519

Answers: A & D