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

1. Question 40: Which two statements are true about raw binary backups? (Choose two.)
2. Question 41: Which statement is true about cold backups?
3. Question 42: You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them. Your goal…
4. Question 43: Which two are valid uses for binary logs on a MySQL instance? (Choose two.)
5. Question 45: Which three requirements must be enabled for group replication? (Choose three.)
6. Question 46: Which three are types of InnoDB tablespaces? (Choose three.)
7. Question 47: You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached. You find that the disk system…
8. Question 48: The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connecti…
9. Question 50: What is the correct syntax for using transparent data encryption with an existing InnoDB table?
10. Question 52: Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database. Company policy is to create a backup every day. The…