The log in which data changes received from a replication master server are written are . . . . . . . .
A. error log
B. general query log
C. binary log
D. relay log
Answer: Option D
Solution (By Examveda Team)
This question is about how MySQL manages data replication. Imagine you have two MySQL servers: a master server and a slave server. The master server is the original source of data, and the slave server keeps a copy of that data.When data changes happen on the master server (like adding new data or updating existing data), these changes are recorded in a special log called the binary log.
The slave server then reads these changes from the binary log and applies them to its own copy of the database.
So, the answer to the question is Option C: binary log.
Let's look at why the other options are incorrect:
* Option A: error log: This log records errors that occur during the operation of the MySQL server. It doesn't directly relate to replication.
* Option B: general query log: This log records all SQL queries executed on the server. It's not specifically used for replication.
* Option D: relay log: This log is used by the slave server to store the changes it receives from the master server before applying them to its database. While it's involved in replication, the changes are initially recorded in the binary log.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion