Big 11.11 Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 36 Topic 4 Discussion

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 36 Topic 4 Discussion

1z0-888 Exam Topic 4 Question 36 Discussion:
Question #: 36
Topic #: 4

Consider that local disk files are accessible via MySQL with commands such as:

mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;

What change could be made to stop any breach via this insecurity?


A.

executing REVOKE LOAD FROM *.*


B.

setting the --local-service=0 option when starting mysqld


C.

executing REVOKE FILE FROM *.*


D.

executing REVOKE FILE ON *.* FROM ‘ ’ @’%’


E.

setting the --local-infile=0 option when starting mysqld


F.

setting the --open-files-limit=0 option when starting mysqld


Get Premium 1z0-888 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.