1Z0-8881Z0-888 Dumps1Z0-888 Braindumps1Z0-888 Real Questions1Z0-888 Practice Test1Z0-888 dumps freeOracleMySQL 5.7 Database Administrator
QUESTION: 75 You back up by using mysqldump. Which configuration is required on the MySQL Server to allow point-in-time recovery? A. binlog_format=STATEMENT B. log-bin C. apply-log D. bonlog_format=ROW E. gtid_enable Answer: B QUESTION: 76 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 Answer: F QUESTION: 77 You have the following in your my.cnf configuration file: [mysqld] default_authentication_plugin=sha256_password You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.