What must you use to read data from a table in your database and write it to an external table? (Choose the best answer)
A.
Use SQL* LOADER conventional path load.
B.
Use SQL* LOADER direct path load.
C.
Use CREATE TABLE. . ORAGANIZATION EXTERNAL command with ORACLE_LOADER access driver.
D.
Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access driver.
Explanation:
D
ORACLE_LOADER access driver can perform only data loads. ORACLE_DATAPUMP can do loads and unloads
D is correct
Unloading and Loading Data with the ORACLE_DATAPUMP Access Driver
http://docs.oracle.com/database/121/SUTIL/GUID-084DC623-9656-499C-885B-D8180C07704B.htm#SUTIL500