Which statement on the master expires binary log files?

Solution (By Examveda Team)

This question is about how MySQL manages its log files. Imagine you're writing in a notebook, and each page represents a "binary log file". These files store information about changes made to your database.

The master server is the main database server that holds the original data. It's important to keep the log files safe and organized.

Let's look at the options:
* Option A: SHOW SLAVE STATUS: This command is used to view information about the slave server (a copy of the master server). It doesn't deal with deleting log files on the master server.
* Option B: PURGE MASTER: This is the correct answer! It's like cleaning up your notebook by throwing away old pages you don't need anymore. This command removes expired binary log files from the master server.
* Option C: PURGE SLAVE: This command is for cleaning up log files on the slave server, not the master.
* Option D: SHOW MASTER STATUS: This command shows information about the current binary log file on the master server. It doesn't delete anything.

Therefore, the answer is Option B: PURGE MASTER