Which parameter should be set to unload data in only one file when using COPY INTO?

• A. SINGLE=TRUE
• B. SINGLE=FALSE
• C. MAX_FILES=1
• D. LIMIT=1

Answer: (A)

The option that controls whether the unload outputs a single file is the one that sets SINGLE to TRUE. In COPY INTO, SINGLE determines if the data is written to one file or split into multiple files. Setting SINGLE=TRUE forces all data into a single output file in the destination, which is exactly what you want when you need one file. By default, the operation can produce multiple files, so SINGLE=FALSE (or omitting the option) would not meet the requirement.

The other choices don’t achieve this: LIMIT isn’t an option that controls the number of output files, and MAX_FILES isn’t a standard parameter for COPY INTO to enforce a single file.