1Z0-067 · Question #178
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 A. It succeeds with default settings if the employees table exists in the hr schema. C. It fails if the hr user does not have the create any directory privilege. mmm sql loader express says: sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT=\"DD-MON-YYYY HH24:MI:SS\" https://oracle-base.com/articles/12c/sql-loader-enhancements-12cr1
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
(36 responses)- A72% (26)
- B8% (3)
- D17% (6)
- E3% (1)
Explanation
mmm sql loader express says: sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT="DD-MON-YYYY HH24:MI:SS" https://oracle-base.com/articles/12c/sql-loader-enhancements-12cr1
Topics
Community Discussion
No community discussion yet for this question.