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? (Choose two.)
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.
Suggested Answer:AC🗳️
Note: * SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.
A,C is correct.
When we grant CREATE ANY DIRECTORY to HR, sqlloader will create a temporary directory which is the location of executing sqlldr. If we put the controlfile, parameter file and input data present (name of these file must be the same as name of table), sqlldr will successfully load data into table.
I thought to load data using SQL Loader you need to specify a control file with mapping....
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
rdnkrkmz
Highly Voted 5 years, 11 months agoNorwayOracle
2 years, 10 months agobkk
Highly Voted 4 years, 9 months agoKitevn
Most Recent 3 years, 7 months agosmalls87
4 years, 3 months agosmalls87
4 years, 3 months ago