Oracle Database 12c: Installation and Administration — Question 167

What must you use to read data from a table in your database and write it to an external table?

Answer options

• A. Use SQL* LOADER conventional path load.
• B. Use SQL* LOADER direct path load.
• C. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_LOADER access driver.
• D. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access driver.

Correct answer: D

Explanation

The correct answer is D because the ORACLE_DATAPUMP access driver is specifically designed for efficient data transfer to external tables. Options A and B refer to SQL*LOADER methods that are not suitable for creating external tables. Option C uses the ORACLE_LOADER access driver, which is not the optimal choice for this task.