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

  1. Question 27: A valid raw backup of the shop.customers MyISAM table was taken. You must restore the table. You begin with these steps: 1. Confirm that secure_file_priv=’/var…
  2. Question 28: You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?
  3. Question 29: Examine these statements, which execute successfully: TRUNCATE test; BEGIN; INSERT INTO test(id, name) VALUES(1, “Hello”); ROLLBACK; SELECT id FROM test; Which…
  4. Question 30: Examine this command, which executes successfull mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is tru…
  5. Question 33: You are using mysqlcheck for server maintenance. Which two statements are true? (Choose two.)
  6. Question 34: You have a MySQL system with 500 GB of data that needs frequent backups. You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup…
  7. Question 35: Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently. Which two sets of actions when completed…
  8. Question 36: Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
  9. Question 37: You have configured MySQL Enterprise Monitor to monitor your MySQL server. Which four features are available? (Choose four.)
  10. Question 39: MySQL programs look for option files in standard locations. Which method will show the option files and the order in which they are read?