Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *