MySQL Master-Slave Replication Quiz

 



MySQL Master-Slave Replication Quiz contain set of 10 MCQ questions for MySQL Master-Slave Replication MCQ which will help you to clear beginner level quiz.



 
1. Which parameter will ignore the current event and continue with the next event in replication?

• 1. Ignore_event
  2. sql_slave_skip_counter
  3. skip_slave_event
  4. sql_skip_counter

2. What is the privilege required for the slave user?

• 1. REPLICATION SLAVE
  2. REPLICATION CLIENT
  3. SELECT
  4. ALL

3. What is the default Port used in MySQL replication?

• 1. 22
  2. Random
  3. 3307
  4. 3306

4. What should be the value of server-id for master and slave

• 1. 1
  2. 2
  3. Unique
  4. 0

5. Which option in mysqldump writes the binlog co-ordinates required for replication configuration?

• 1. binlog
  2. dump-binlog
  3. master-data
  4. debug

6. Which backups can be used for configuring replication?

• 1. mysqldump
  2. Mysql Enterprise Backup
  3. Percona Xtra backup.
  4. All of the above

 
7. What is the command used for starting SQL Thread?

• 1. start sql_thread
  2. start slave
  3. start slave sql_thread
  4. None of the Above

8. Master-Slave replication, binlog should be enabled in.

• 1. Master
  2. Slave
  3. Both Master & Slave
  4. None

9. Which option disables the slave to start automatically whenever mysql is restarted.

• 1. skip-slave
  2. disable-slave
  3. skip-slave-start
  4. None of the above

10. Which command displays the status of the slave.

• 1. show slave status
  2. show slave
  3. print slave status
  4. show status