Question 31
Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?
Question 32
You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files?
(Choose two.)
Which two steps should you perform to safely remove some of the older binary log files?
(Choose two.)
Question 33
Consider:

What does the range value in the type column mean?

What does the range value in the type column mean?
Question 34
You have a server that has very limited memory but has a very large table.
You will use mysqldumpto back up this table.
Which option will ensure mysqldumpwill process a row at a time instead of buffering a set of rows?
You will use mysqldumpto back up this table.
Which option will ensure mysqldumpwill process a row at a time instead of buffering a set of rows?
Question 35
A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup? (Choose two.)
Which two will optimize the security of this setup? (Choose two.)
