Oracle Database Administration I — Question 73

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

Answer options

• A. dump files
• B. control files
• C. password files
• D. bad files
• E. input files

Correct answer: B, D, E

Explanation

The correct answers are B, D, and E because control files are necessary for SQL*Loader to define how data should be loaded, bad files log records that cannot be loaded due to errors, and input files contain the actual data to be loaded. Dump files and password files are not directly related to the conventional path SQL*Loader operation in this context.