Upgrade Oracle DBA 11g to Oracle Database 12c — Question 30

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 statements are A, D, and E. Option A is true as SQL*Loader can indeed handle multiple files for multiple tables. Option D is also correct because it allows for table creation from external data. Option E is right because SQL*Loader can generate unique values during the load process. However, option B is incorrect since SQL*Loader does not extract or reorganize data; it only loads it, and option C is false because SQL*Loader supports both direct path and conventional path loading methods.