Which three statements are true regarding the SQL* Loader operation performed using the control file?

Examine the contents of SQL loader control file: Which three statements are true regarding
the SQL* Loader operation performed using the control file?

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:



Leave a Reply 0

Your email address will not be published. Required fields are marked *