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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion