MySQL for Database Administrators Ed 5.1 Quiz Questions and Answers

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

Answer :
  • Undo tablespace

Explanation :

NULL

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

Answer :
  • [client]

Explanation :

NULL

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

Answer :
  • Binary log

Explanation :

NULL

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

Answer :
  • plugin-load=audit_log.so

Explanation :

NULL

A user is logged in to his computer david-laptop as the Linux user dave. He logs in to MySQL by typing the following command: mysql -u david -h dbserver2 -p Assuming that the server uses caching_sha2_password, which of the following mysql.user accounts authenticates him?

Answer :
  • david@david-laptop

Explanation :

NULL

Which of the following statements prevent the kari@localhost user from logging in?

Answer :
  • ALTER USER kari@localhost ACCOUNT LOCK
  • DROP USER kari@localhost

Explanation :

NULL

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

Answer :
  • ssl=0

Explanation :

NULL

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.

Explanation :

NULL

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

Answer :
  • RESET

Explanation :

NULL

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

Explanation :

NULL