Examine the contents of SQL loader control file: 
Which three statements are true regarding the SQL* Loader operation performed using the control
file?
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.
Explanation:
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.
Something wrong with picture?
Picture for this question is in 77 question.
The graphic for this question is shown for Q77. The given answer, ABE is wrong. The SQL*Loader controlfile parameters are in the wrong order. The correct order is to have “field names first file” AFTER “load data” and BEFORE the first “infile”. The order shown in the question throws a syntax error. Answers B & E are correct. However, answer A is wrong because the table HAS to exist before running the SQL*Loader session. C is wrong because record terminators do not need to be specified. The data files are CSV files whose field and record terminators are known defaults and hence do not need to be declared. D is wrong because “field names first file” means only the first data file (myfile1.dat) will contain the names of the table columns in the first record. D would only be correct if the parameter were “field names all files”. So there are only 2 correct answers not 3, B&E.
H*T*H
BCE