Oracle Database 12c: Installation and Administration — Question 192

In which two scenarios do you use SQL* Loader to load data? (Choose two.)

Answer options

• A. Transform the data while it is being loaded into the database.
• B. Use transparent parallel processing without having to split the external data first.
• C. Load data into multiple tables during the same load statement.
• D. Generate unique sequential key values in specified columns.

Correct answer: C, D

Explanation

The correct answers are C and D because SQL*Loader allows loading data into multiple tables in one load statement and can generate unique sequential key values for specified columns. Options A and B are incorrect as they do not represent typical use cases for SQL*Loader, which focuses more on data loading than data transformation or the requirement of processing external data.