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.
AC
A and C
A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
http://docs.oracle.com/database/121/SUTIL/ldr_express.htm#SUTIL3951
A and C are correct.
Controlfile and loader file need not be specified!
AC
AC
SQL loader express mode.
table is wrong option for sqlldr… why are u repating bad anwsers all time?
In Oracle Database 12c, SQL*Loader has a new parameter, TABLE, that turns on express mode.
The value of the TABLE parameter is the name of the table that SQL*Loader will load.
If TABLE is the only parameter specified, then SQL* loader will do the following:
1. Look for a data file in the current directory with the same name as the table being loaded and with an extension of “.dat”. The case of the name of the data file is the same as the case of the table name specified for the TABLE parameter
2. Assume the order of the fields in the data file matches the order of the columns in the table
3. The fields are terminated by commas, but there is no enclosure character
A,C are correct
A is correct. CREATE ANY DIRECTORY only has sense if external tables are used. In this case sqlloader will automatically switch to direct path load.
A,C are correct
A and C cannot be true together since A would be false if C was true, because A says nothing about the CREATE ANY DIRECTORY priviledge. A is true. C is false(tested). B is false. D is false. So, the question on the exam either is one choice or there’s more answers.
Only A is correct.
C is not (https://docs.oracle.com/database/121/SUTIL/GUID-51843558-56ED-4E6D-B100-5EB316D554E2.htm#SUTIL3998)