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.
Join The Discussion