Validation mode can take the below options

Validation mode can take the below options
A . RETURN_<n>_ROWS
B. RETURN_ERRORS
C. RETURN_ALL_ERRORS
D. RETURN_SEVERE_EERORS_ONLY

View Answer

Answer: A,B,C

Explanation:

VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified: