The LOCAL capability for client library is enabled by . . . . . . . .
A. -enabled-local-file
B. -enable-local-infile
C. -enable-global-file
D. -enable-local-file
Answer: Option B
Solution(By Examveda Team)
-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.-enabled-local-file: This option does not exist in MySQL. It is not a valid option for enabling the LOCAL capability for the client library.
-enable-global-file: This option is incorrect. There is no option named -enable-global-file in MySQL for enabling the LOCAL capability for the client library.
-enable-local-file: This option is similar to the correct option, but the correct option is -enable-local-infile.
Therefore, the correct option for enabling the LOCAL capability for the client library is Option B: -enable-local-infile.
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