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 10 of 11.

1. Question 121: Which two statements are true about MySQL server multi-source replication? (Choose two.)
2. Question 122: Which command enables rule-based MySQL Auditing capabilities?
3. Question 123: Which four are types of information stored in the MySQL data dictionary? (Choose four.)
4. Question 124: Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)
5. Question 128: A clean shutdown was performed with innodb_fast_shutdown=0. While you were manipulating files, all files were accidentally deleted from the top-level data dire…
6. Question 129: Which condition is true about the use of the hash join algorithm?
7. Question 130: Which three are requirements for a secure MySQL Server environment? (Choose three.)
8. Question 131: Examine this parameter setting: audit_log=FORCE_LOG_PERMANENT What effect does this have on auditing?
9. Question 133: Your MySQL environment has asynchronous position based-replication with one master and one slave. The slave instance had a disk I/O problem, so it was stopped.…
10. Question 136: Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)