Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)
A.
An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
B.
The SQL* Loader data file myfile1.dat has the column names for the EMP table.
C.
The SQL* Loader operation fails because no record terminators are specified.
D.
Field names should be the first line in the both the SQL* Loader data files.
E.
The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
Suggested Answer:ABE🗳️
A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with. B (not D): Note: * SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE directive could not be processed. Action: Check the listed data file and fix it. Then retry the operation E: * A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields. * Fields with embedded commas must be quoted. Example: 1997,Ford,E350,"Super, luxurious truck" Note: * SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.
A maybe not right, C,D must be wrong.
Seem to be the CREATE TABLE statement will be there while generating .ctl file,
but you need to manually execute the CREATE statement anyway.
https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/sqlldr/sqlldr_table_creation.htm
I'am confused with this, "A" can't be correct, but some guys tell what thay chosen this answer and got that point.
http://www.briefmenow.org/oracle/which-three-statements-are-true-regarding-the-sql-loader-operation-performed-using-the-control-file-2/
upvoted 3 times
...
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.
jackymak
3 years, 3 months agohggz
5 years, 2 months ago