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

1. Question 91: Which two statements are true about MySQL Enterprise Backup? (Choose two.)
2. Question 92: How can mysql_multi be configured to allow MySQL instances to use the same port number?
3. Question 93: What does the slave I/O thread do?
4. Question 95: Which two statements are true about MySQL Installer? (Choose two.)
5. Question 96: Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)
6. Question 97: Which statement is true about InnoDB persistent index statistics?
7. Question 100: Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
8. Question 102: Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?
9. Question 104: t is a non-empty InnoDB table. Examine these statements, which are executed in one session: BEGIN; SELECT * FROM t FOR UPDATE; Which is true?
10. Question 105: A user wants to connect without entering his or her username and password on the Linux command prompt. Which three locations can be used to store the user’s my…