Which two methods allow a DBA to reset a user's password? (Choose two.)

• A. ALTER USER statement
• B. SET PASSWORD statement
• C. mysqladmin client program
• D. GRANT statement
• E. mysql_secure_installation utility

Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

• A. Remove world read privileges from the public_key.pem file.
• B. Remove the world read/execute privilege from the accounting directory.
• C. Remove group read/write privileges from the private_key.pem file.
• D. Remove world read privileges from the server-cert.pem certificate file.
• E. Change the parent directory owner and group to mysql.
• F. Change the group ownership of the mysql directory to the mysql user group.

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

• A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
• B. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
  'tom'@'%';
• C. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
  GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
• D. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
  GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster?
(Choose two.)

• A. Create the backup by using the --set-gtid-purged=OFF option.
• B. Remove the @@GLOBAL.gtid_executed statement from the dump file.
• C. Restore using the --set-gtid-purged=OFF option.
• D. Remove the group replication plugin from each instance before restoring.
• E. Remove the @@GLOBAL.gtid_purged statement from the dump file.
• F. Stop all instances except the primary read/write master instance and run the restore.

Which two statements are true about using backups of the binary log? (Choose two.)

• A. They allow for point-in-time recovery of the data.
• B. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
• C. Binary logs can always be used to unapply unwanted schema changes.
• D. Multiple binary logs can be used to restore data.
• E. Multiple binary logs can be applied in parallel for faster data restoration.