
Answer-first summary for fast verification
Answer: FIELD_OPTIONALLY_ENCLOSED_BY, EMPTY_FIELD_AS_NULL
The question asks for parameters that differentiate between empty strings and NULL values during data unloading. OPTION C (FIELD_OPTIONALLY_ENCLOSED_BY) allows empty strings to be enclosed in quotes (e.g., ""), making them distinguishable from NULL values which would not be enclosed. OPTION D (EMPTY_FIELD_AS_NULL) when set to FALSE ensures empty fields are treated as empty strings rather than NULLs, preserving the distinction. The community discussion shows 100% consensus on CD, with detailed explanations that FIELD_OPTIONALLY_ENCLOSED_BY enables empty string enclosure and EMPTY_FIELD_AS_NULL controls whether empty fields become NULLs. Other options are less suitable: A (ESCAPE_UNENCLOSED_FIELD) handles escaping, not NULL/empty differentiation; B (REPLACE_INVALID_CHARACTERS) deals with character validation; E (SKIP_BLANK_LINES) skips entire lines, not field-level differentiation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select two.)
A
ESCAPE_UNENCLOSED_FIELD
B
REPLACE_INVALID_CHARACTERS
C
FIELD_OPTIONALLY_ENCLOSED_BY
D
EMPTY_FIELD_AS_NULL
E
SKIP_BLANK_LINES