1Z0-060 · Question #24
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 the database. C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege. SQLLoader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.
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 the database.
- 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
(31 responses)- A71% (22)
- B6% (2)
- D23% (7)
Explanation
SQLLoader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.
Topics
Community Discussion
No community discussion yet for this question.