Without LOCAL, LOAD DATA is . . . . . . . .

Solution (By Examveda Team)

This question is about how LOAD DATA works in MySQL.
LOAD DATA is a command that lets you import data into a table from a file.
LOCAL is a keyword you can use with LOAD DATA to tell MySQL to read the file from your local computer.
Without LOCAL, LOAD DATA reads the file from the server where MySQL is running.
So, the answer is Option B: less efficient.
Here's why:
- When you use LOCAL, MySQL can access the data directly from your computer, which is generally faster.
- Without LOCAL, MySQL has to transfer the data from the server, which adds extra time and makes the process slower.