To add multiple records to a database from an external file, you use the ____ statement with the name of the local text file that contains the records you want to add.
A) INSERT DATA
B) LOAD DATA
C) INSERT RECORDS
D) UPLOAD RECORDS

Question

Quizplus · Accepted Answer

The correct statement to use is LOAD DATA, followed by the keyword INFILE and the name of the local text file containing the records to be added. This is a commonly used method for bulk importing data into a database. INSERT DATA and INSERT RECORDS are not valid SQL statements, and UPLOAD RECORDS is not a standardized command.

To Add Multiple Records to a Database from an External