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.

How do you persist a remote instance's configuration settings for MySQL InnoDB cluster when the version of MySQL Server is prior to 8.0.11?

Answer :
  • Connect to the remote instance and use MySQL Shell on the instance to execute dba.configureLocalInstance().

Which of the following options starts the MySQL server with SSL/TLS disabled?

Answer :
  • ssl=0

Which of the following validations is included only when the validate_password_policy variable is set to 2 or STRONG?

Answer :
  • Words are compared to a dictionary file.

Which of the following activities would qualify as scaling out read operations?

Answer :
  • Adding a second server containing a read-only copy of data to drive some webpages

Which of the following activities improves database efficiency the most in a typical (and otherwise unoptimized) MySQL configuration?

Answer :
  • Optimize the database schema and indexes.

Which queries are most important to optimize?

Answer :
  • Queries that execute most frequently