Oracle
1Z0-071 · Question #171
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: $> sqlldr hr/hr@pdb table=employees Which two statements…
The correct answer is A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege. See the full explanation below for the reasoning.
Question
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:
$> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?
Options
- AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in
- BIt fails because no SQL *Loader data file location is specified.
- CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
- DIt fails because no SQL *Loader control file location is specified.
How the community answered
(50 responses)- A74% (37)
- B16% (8)
- D10% (5)
Community Discussion
No community discussion yet for this question.