ON_ERROR ABORT_STATEMENT during bulk load causes what outcome?

• A. Aborts the entire bulk load
• B. Skips the erroneous file
• C. Continues with the next files
• D. Logs error and continues

Answer: (A)

When loading multiple files in a single bulk operation, the ON_ERROR setting controls what happens if an error occurs. Using ABORT_STATEMENT means that any error encountered during the bulk load will stop the entire operation and roll back what the statement started. No data from that bulk load is loaded, and the statement fails so you can fix the issue before re-running. This is in contrast to options that would allow continuing with other files, skipping the problematic file, or logging the error and moving on.