Vidyalelo
MySQL · Q529

MySQL

Programming · MySQL · question 529

Q529

What is SBR replication?

A.
Statement based
Answer
B.
Row based
C.
Column based
D.
Table based

Answer: Option A

Solution

Answer: Option A
Solution:
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.