🎴 Flashcard Mode
SQL Functions, Indexing, and SQL*Loader Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Pick the correct options about Control File
AnswerClick to flip back
A
The LOAD DATA statement is required at the beginning of the control file.
B
The INFILE option specifies where the input file is located
C
Specifying BADFILE, then bad records found during loading will be stored in this file.
D
Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.
E
Field Seperator - how the fields are separated in input file.
💡 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.