Oracle
1Z0-063 · Question #101
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…
The correct answer is B. It fails because no SQL*Loader data file location is specified. D. It fails because no SQL*Loader control file location is specified. See the full explanation below for the reasoning.
Question
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?
Options
- AIt succeeds with default settings if the employees table exists in the hr schema.
- 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.
- EIt succeeds and creates the employees table in the HR schema.
How the community answered
(16 responses)- A6% (1)
- B75% (12)
- C6% (1)
- E13% (2)
Community Discussion
No community discussion yet for this question.