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

1. Question 15: Examine this statement: mysql> DROP ROLE r_role1, r_role2; Which two are true? (Choose two.)
2. Question 17: Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
3. Question 18: You plan to install MySQL Server by using the RPM download. Which two statements are true? (Choose two.)
4. Question 19: Consider this shell output and executed commands: [root@oel7 ~]# ps aux | grep mysqld mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid [roo…
5. Question 21: Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’. Which command will do this?
6. Question 22: What does the binlog dump thread do?
7. Question 23: Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)
8. Question 24: Examine this command, which executes successfully: shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are t…
9. Question 25: Which two MySQL Server accounts are locked by default? (Choose two.)
10. Question 26: Which two are true about binary logs used in asynchronous replication? (Choose two.)