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.
ans a,c
ANS A,C
Therefore, when the EXECUTE option is specified, you must have the CREATE ANY DIRECTORY privilege.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loader-express-mode.html#GUID-51843558-56ED-4E6D-B100-5EB316D554E2
Since other options are wrong, we’ve got to choose A and C