In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees
Which two statements are true about this command? (Choose two.)
A.
It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
B.
It fails because the SQL *Loader control file location is not specified.
C.
It fails because the SQL *Loader data file location is not specified.
D.
It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in
the database.
E.
It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
confirmed.
NOT A – contradicted with D.
NOT B – In express mode, a SQL*Loader control file is not used.
NOT C – If no data file is specified, then it looks for a file named table-
name.dat in the current directory.
D – If you activate SQL*Loader express mode by specifying only the TABLE
parameter, then SQL*Loader uses default settings for a number of other
parameters.
E – For some errors, SQL*Loader express mode automatically switches from the
default external tables load method to direct path load. An example of when
this might occur would be if a privilege violation caused the CREATE
DIRECTORY SQL command to fail.