Oracle Database 12c: Advanced Administration — Question 38

Which three statements are true about the SQL*Loader utility?

Answer options

• A. It can be used to load data from multiple external files into multiple tables.
• B. It can be used to extract and reorganize data from external files, and then load it into a table.
• C. It can be used to load data from external files using direct path only.
• D. It can be used to create tables using data that is stored in external files.
• E. It can be used to generate unique sequential values in specified columns while loading data.

Correct answer: A, D, E

Explanation

The correct options A, D, and E highlight the capabilities of SQL*Loader to load from multiple files, create tables from external data, and generate unique values. Option B is incorrect because SQL*Loader does not extract or reorganize data; it simply loads it. Option C is also wrong as SQL*Loader can use both conventional and direct path methods for loading data.