Multiple choice technology databases

What are the components needed for sql loader?.

  1. Control File

  2. Data File

  3. Target Table

  4. Bad File
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

SQL Loader requires: a Control File (defines load rules), Data File (source data), and Target Table (where data loads). The Bad File is an OUTPUT file that records rejected records - it's created during loading, not required beforehand.

AI explanation

SQL*Loader (Oracle's bulk-load utility) requires: a Control File (defines load rules — field mappings, file format, table target), a Data File (the raw input records), and a Target Table (the pre-existing Oracle table to load into). The Bad File is an output SQL*Loader generates during the run to capture rejected records — it's optional and not something you must supply beforehand, which is why it's correctly excluded from the required-components list.

Keep practicing — related questions