MySQL 8.0 Database Administrator Free Practice Exam Questions

103 real MySQL 8.0 Database Administrator exam questions with answers and AI explanations. Oracle certification prep — page 7 of 11.

  1. Question 80: Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
  2. Question 81: Examine this command, which executes successfully: mysqlpump -–user=root --password > full_backup.sql Which two databases will be excluded from this dump? (Cho…
  3. Question 82: Which two are use cases of MySQL asynchronous replication? (Choose two.)
  4. Question 83: Which three actions are effective in capacity planning? (Choose three.)
  5. Question 84: An attempt to recover an InnoDB Cluster fails. Examine this set of messages and responses: host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfigur…
  6. Question 85: Examine this command, which executes successfully: cluster.addInstance(‘<user>@<host>:<port>’, {recoveryMethod: ‘clone’}) Which three statements are true? (Cho…
  7. Question 86: A MySQL server is monitored using MySQL Enterprise Monitor’s agentless installation. Which three features are available with this installation method? (Choose…
  8. Question 87: Which two methods allow a DBA to reset a user's password? (Choose two.)
  9. Question 89: Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
  10. Question 90: Which step or set of steps can be used to rotate the error log?