ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which statement suspends the replication related activity of the slave server?

Answer & Solution
Correct Answer: Option C
The STOP SLAVE statement suspends the replication-related activity of the slave server in MySQL.
When you execute this statement on the slave server, it stops the SQL thread and IO thread, effectively pausing replication.
Option A, RESUME SLAVE, is incorrect because RESUME SLAVE is used to resume replication activity after it has been suspended using STOP SLAVE.
Option B, START SLAVE, is incorrect because START SLAVE is used to start the replication process on the slave server after it has been stopped or initialized.
Option D, GET SLAVE, is incorrect because there is no such statement as GET SLAVE in MySQL; instead, SHOW SLAVE STATUS is used to view the status of the slave server and its replication activity.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.