MySQL for Database Administrators Ed 5.1 Quiz Questions and Answers

In addition to the [mysqldump] group, the mysqldump program reads options from which of the following option groups?

Answer :
  • [client]

Which of the following modes clears the Enterprise Firewall whitelist for a particular user?

Answer :
  • RESET

A relay slave is:

Answer :
  • A slave server that acts as a master to another slave

Which of the following statements are correct about Group Replication in single-primary mode?

Answer :
  • One server accepts writes, the others are read only.

For which installation method must you create the data directory manually?

Answer :
  • Binary Archive installation for Linux

Many installations of MySQL 8.0 are “secure by default” and create a random root password at installation time. Which two of the following are valid ways to change that password?

Answer :
  • Issue a mysqladmin ... password command at the command line to change the initial password
  • Log in to MySQL with the initial password and issue an ALTER USER statement to change it.

Which of the following parameters to the --protocol option works on all operating systems, both locally and remotely?

Answer :
  • TCP

Which of the following cannot be a target for storing a table when you execute a CREATE TABLE ... TABLESPACE statement?

Answer :
  • Undo tablespace

Which log is not stored in a human-readable text format?

Answer :
  • Binary log

Which of the following my.cnf server options enables the audit log?

Answer :
  • plugin-load=audit_log.so