Which two statements are true about the command?

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?

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.



Leave a Reply 0

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