Oracle Database 12c: Advanced Administration — Question 69

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?

Answer options

• A. It succeeds with default settings if the employees table exists in the hr schema.
• B. It fails because no SQL*Loader data file location is specified.
• C. It fails if the hr user does not have the create any directory privilege.
• D. It fails because no SQL*Loader control file location is specified.
• E. It succeeds and creates the employees table in the HR schema.

Correct answer: B, D

Explanation

The command fails because both a data file and a control file are necessary for SQL*Loader to process the data. Therefore, options B and D are correct as they address the absence of these crucial file locations, while the others do not accurately reflect the requirements for a successful SQL*Loader operation.