MySQL-5-7-Database-Administrator-(1Z0-888).pdf - 1Z0-888 Dumps 1Z0-888 Braindumps 1Z0-888 Real Questions 1Z0-888 Practice Test 1Z0-888 dumps free Oracle

MySQL-5-7-Database-Administrator-(1Z0-888).pdf - 1Z0-888...

This preview shows page 1 - 3 out of 6 pages.

1Z0-888 1Z0-888 Dumps 1Z0-888 Braindumps 1Z0-888 Real Questions 1Z0-888 Practice Test 1Z0-888 dumps free Oracle MySQL 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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture