Oracle Database 12c: Installation and Administration — Question 10

Which two statements are true about using SQL*Loader? (Choose two.)

Answer options

• A. It can load data from external files by using the direct path only.
• B. It can load data into multiple tables using the same load statement.
• C. It can load data into only one table at a time.
• D. It can generate unique sequential key values in specified columns.
• E. It can load data from external files by using the conventional path only.

Correct answer: A, C

Explanation

The correct answers are A and C. Option A is true because SQL*Loader can load data using the direct path, which is often faster. Option C is also accurate as SQL*Loader processes data one table at a time, which is a limitation. Options B, D, and E are incorrect as SQL*Loader does not support loading into multiple tables simultaneously and can utilize both direct and conventional paths for loading data.