Which is the log in which data changes received from a replication master server are written?

Solution (By Examveda Team)

This question is about how MySQL keeps track of changes when you have multiple servers working together (replication). Imagine you have a main server (the "master") and a backup server (the "slave"). When something changes on the master, the slave needs to know about it so it can stay up-to-date.

The answer is Option D: relay log. Here's why:
* Relay log: This is where the slave server stores the changes it receives from the master. Think of it like a to-do list for the slave. It tells the slave what updates to apply to its own database.
Let's look at the other options and why they're not the right answer:
* Error log: This log records errors that happen within the MySQL server. It's not related to replication.
* General query log: This log keeps track of all the SQL statements that are executed on the server. It's helpful for debugging, but it doesn't specifically handle replication changes.
* Binary log: This log is on the master server and stores the changes that happen on the master. The slave reads from this log to figure out what changes it needs to make.
So, to summarize: the relay log is the "to-do list" for the slave server, letting it know what updates to apply from the master server's binary log.