Multiple choice technology databases

Which are all true in loading multi-line records?

  1. Specifying carriage return statement in control file

  2. Position based loading

  3. Sperators as comments in the source file

  4. Carriage return
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

For multi-line records in SQL*Loader: (A) You can specify carriage return/line feed handling in the control file using clauses like CONTINUEIF or TERMINATED BY; (B) Position-based loading (fixed format) can span multiple lines using POSITION clauses; (D) Carriage return characters can be explicitly handled. Option C is incorrect - separators are not treated as comments.

Keep practicing — related questions