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

1. Question 1: Which two are features of MySQL Enterprise Firewall? (Choose two.)
2. Question 2: Examine this MySQL client command to connect to a remote database: mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode= Which two --ssl-mode value…
3. Question 3: You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?
4. Question 4: Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
5. Question 5: You execute this command: shell> mysqlpump --exclude-databases=% --users Which statement is true?
6. Question 6: You plan to take daily full backups, which include the ndbinfo and sys (internal) databases. Which command will back up the databases in parallel?
7. Question 7: Your MySQL server is running on the Microsoft Windows platform. Which three local connection protocols are available to you? (Choose three.)
8. Question 9: Which three are characteristics of a newly created role? (Choose three.)
9. Question 10: Examine this SQL statement: mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION; Which two are true? (Choose two.)
10. Question 14: Examine this list of MySQL data directory binary logs: binlog.000001 binlog.000002 ..... binlog.000289 binlog.000300 binlog.000301 binlog.index Now examine thi…