Oracle Database 12c: Installation and Administration — Question 1
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
Which two statements are true regarding the command? (Choose two.)
Answer options
- A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
- 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.
Correct answer: A, C
Explanation
Option A is correct because SQL *Loader can operate with default settings if the target table exists. Option C is also correct since the lack of the CREATE ANY DIRECTORY privilege would prevent the HR user from accessing the necessary directories for file loading. Options B and D are incorrect because the command can still execute without explicitly specifying a data or control file location if defaults are in place.