Oracle Database 12c: Installation and Administration — Question 85
In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
Which two statements are true about this command? (Choose two.)
Answer options
- A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
- B. It fails because the SQL *Loader control file location is not specified.
- C. It fails because the SQL *Loader data file location is not specified.
- D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
- E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
Correct answer: D, E
Explanation
The correct answers are D and E because the command will execute successfully if the EMPLOYEES table is already defined, and the HR user does not need the CREATE DIRECTORY privilege to use SQL *Loader in this context. Options A, B, and C are incorrect as they imply issues that do not prevent the command from executing successfully when the table exists and the necessary privileges are present.