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.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-sql-loader-express-mode.html#GUID-8C235861-2A8B-4196-9705-E6FFED0C0C99
SQL Loaded Express mode doesn't need a control file but uses the table column definition in ALL_TAB_COLUMNS to process the load.
DE confirmed.
confirmed.
NOT A – contradicted with D.
NOT B – In express mode, a SQL*Loader control file is not used.
NOT C – If no data file is specified, then it looks for a file named table-
name.dat in the current directory.
D – If you activate SQL*Loader express mode by specifying only the TABLE
parameter, then SQL*Loader uses default settings for a number of other
parameters.
E – 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.
This section is not available anymore. Please use the main Exam Page.1z0-062 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.
Ray520
3 years agoPhoenix22
5 years, 1 month agoNorthKorean
5 years, 1 month ago