Examveda

Which of the following is more efficient?
LOAD DATA, INSERT

A. 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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous