Multiple choice technology databases

What is control file?

  1. It describe how to interpret the flat file and options to load the data.

  2. It describe the location and format of the data file.

  3. It describe the location of the Bad and Discard records file .

  4. It has the control to connect database
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The control file in SQL Loader specifies: how to interpret the data format (field delimiters, data types), location and format of the source data file, and paths for bad/discard files. Database connection parameters are passed on the command line (userid=), not defined in the control file.

Keep practicing — related questions