Examveda
Examveda

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

A. RESUME SLAVE

B. START SLAVE

C. STOP SLAVE

D. GET SLAVE

Answer: Option C

Solution(By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous