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?
A.
It succeeds with default settings if the employees table exists in the hr schema.
B.
It fails because no SQL*Loader data file location is specified.
C.
It fails if the hr user does not have the create any directory privilege.
D.
It fails because no SQL*Loader control file location is specified.
E.
It succeeds and creates the employees table in the HR schema.
B&D
AE
SQL> sqlldr hr/hr table=employees
This command invokes SQL*Loader Express Mode, so BD are wrong
E option is not complete, the complete E is like following:
E. It succeeds and creates the employees table in the HR schema, even if the HR user does not have the CREATE ANY DIRECTORY privilege.
I think A,C
AE
AC
AC