Which of the following is more efficient?
LOAD DATA, INSERT
LOAD DATA, INSERTA. LOAD DATA
B. INSERT
C. Same
D. Indeterminate
Answer: Option A
Solution (By Examveda Team)
This question asks about the efficiency of two ways to add data to a MySQL table: LOAD DATA and INSERT.LOAD DATA is designed for importing large amounts of data from a file. It's like copying and pasting data directly into the table, making it very fast.
INSERT is used for adding data row-by-row. While it works for smaller datasets, it can be slower for large imports.
Therefore, the answer is Option A: LOAD DATA
LOAD DATA is generally more efficient for importing large amounts of data.

Join The Discussion