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.
Option BCDE are incorrect.But it has to chooes two, so just AC.
For B,"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." ref:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loader-express-mode.html#GUID-0F35B551-861B-450D-8BF3-2312893A67D7
This section is not available anymore. Please use the main Exam Page.1z0-063 Exam Questions
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.
hilaire
3 years, 10 months agobadguy001djh
4 years, 1 month agoSugar
5 years agojoe_doe
5 years agosherifelia
5 years, 4 months ago