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

1. Question 108: Which two queries are examples of successful SQL injection attacks? (Choose two.)
2. Question 109: Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
3. Question 110: Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
4. Question 113: Examine Joe's account: CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*' GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%' All existing connections for joe are killed. Whi…
5. Question 114: You have an InnoDB Cluster configured with three servers. Examine this command, which executes successfully: mysqldump -uroot -p -d mydatabase > mydatabase_bac…
6. Question 115: Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
7. Question 116: You wish to store the username and password for a client connection to MySQL server in a file on a local file system. Which is the best way to encrypt the file?
8. Question 117: You are backing up raw InnoDB files by using mysqlbackup. Which two groups of files will be backed up during a full backup? (Choose two.)
9. Question 119: Which statement is true about InnoDB persistent index statistics?
10. Question 120: Examine this MySQL Shell command: dba.rebootClusterFromCompleteOutage() Which two statements are true? (Choose two.)