Examveda

What is SBR replication?

A. Statement based

B. Row based

C. Column based

D. Table based

Answer: Option A

Solution (By Examveda Team)

This question asks about a type of replication in MySQL, which is a way to keep multiple copies of your database synchronized. Let's break down the options:
Option A: Statement based
This means that MySQL replicates the actual SQL statements that modify data. Imagine it like copying and pasting commands from one database to another.
Option B: Row based
This replication method focuses on copying individual rows of data that change. It's like sending a message saying, "Hey, this row got updated, copy it over!"
Option C: Column based
This option isn't a standard type of replication in MySQL.
Option D: Table based
This option isn't a standard type of replication in MySQL.
So, based on the above explanations, the most likely answer is Option A: Statement based and Option B: Row based. These are common replication methods used in MySQL.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous