Oracle Service Cloud Developer — Question 35

There are many different ways to load data into database tables.
Which method does Oracle strongly recommend?

Answer options

• A. generic connectivity via ODBC or JDBC
• B. database gateways to open systems and mainframes
• C. Oracle GoldenGate
• D. Oracle Data Pump
• E. SQL*Loader import
• F. data loading via external tables

Correct answer: F

Explanation

Oracle recommends using external tables for data loading because this method allows for efficient access and manipulation of data in flat files without the need for intermediate steps. Other options like SQL*Loader and Oracle GoldenGate are useful but do not offer the same level of integration and performance for bulk data loading as external tables do.