Multiple choice technology databases

Pick the correct options about Control File

  1. The LOAD DATA statement is required at the beginning of the control file.

  2. The INFILE option specifies where the input file is located

  3. Specifying BADFILE, then bad records found during loading will be stored in this file.

  4. Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.

  5. Field Seperator - how the fields are separated in input file.
Reveal answer Fill a bubble to check yourself
A,B,C,D,E Correct answer
Explanation

All statements accurately describe SQL*Loader control file components. LOAD DATA is required at the beginning. INFILE specifies input location. BADFILE stores rejected records. DISCARDFILE holds records failing WHEN conditions. Field separators define how input fields are delimited.

Keep practicing — related questions