On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table
in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?
A.
It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in
the database.
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.
Explanation:
Note:
* SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that
establish session characteristics.
New enhancement on 12c called ‘express mode loading’
When specify only ‘table’ parameter, can go without controlfile
http://www.oracle.com/technetwork/database/enterprise-edition/learnmore/sqlldr-express-mode-wp-1991038.pdf
A&C
this question is not right. only A is true. Does not make any sense why hr would have to create a directory in an express sqlldr
I agree with Jav. Only A although they ask for ‘two’ which is in my opinion wrong.
A & C. Note that the external tables option uses directory objects in the database to indicate where all datafiles are stored and to indicate where output files, such as bad files and discard files, are created. You must have READ access to the directory objects containing the datafiles, and you must have WRITE access to the directory objects where the output files are created. If there are no existing directory objects for the location of a datafile or output file, SQL*Loader will generate the SQL statement to create one. Therefore, when the EXECUTE option is specified, you must have the CREATE ANY DIRECTORY privilege
Incorrect.
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.
Source: https://docs.oracle.com/database/122/SUTIL/oracle-sql-loader-express-mode.htm#SUTIL3973
A C
A,C
If no data file is specified, then SQL lOADER looks for a file named table-name.dat in the current directory.
External tables is the load method. 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
AC