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

1. Question 53: You issue this command: SHOW SLAVE STATUS - In the output, there is a value for Seconds_behind_master. How is this time calculated?
2. Question 54: All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. You must configure InnoDB Cluster to use SSL for group communication. W…
3. Question 55: You are considering using file-system snapshots to back up MySQL. Which three statements are true? (Choose three.)
4. Question 56: You want to dump all databases with names that start with "db". Which command will achieve this?
5. Question 57: Which two statements are true about the binary log encryption feature? (Choose two.)
6. Question 58: Which two statements are true about the mysqld-auto.cnf file? (Choose two.)
7. Question 60: Which three are types of information stored in the MySQL data dictionary? (Choose three.)
8. Question 62: You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server. Which value of --…
9. Question 63: You wish to protect your MySQL database against SQL injection attacks. Which method would fail to do this?
10. Question 67: Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?