📊 MySQL
Q. The LOCAL capability for client library is enabled by . . . . . . . .
  • (A) -enabled-local-file
  • (B) $sth
  • (C) -enable-global-file
  • (D) -enable-local-file
💬 Discuss
✅ Correct Answer: (B) $sth

Explanation: -enable-local-infile: This option enables the capability to load data from local files using the client library. It allows MySQL client programs to read data files from the client host rather than the server host. Enabling this option allows the use of the LOAD DATA LOCAL INFILE statement to load data from local files into database tables. It is a security feature that can be controlled by server administrators.

Explanation by: Bhagwan Das
-enable-local-infile: This option enables the capability to load data from local files using the client library. It allows MySQL client programs to read data files from the client host rather than the server host. Enabling this option allows the use of the LOAD DATA LOCAL INFILE statement to load data from local files into database tables. It is a security feature that can be controlled by server administrators.

💬 Discussion

📊 Question Analytics

👁️
85
Total Visits
📽️
1 y ago
Published
🎖️
Bhagwan Das
Publisher
📈
90%
Success Rate