SBR replication is . . . . . . . .
A. Statement based
B. Row based
C. Column based
D. Table based
Answer: Option A
Solution (By Examveda Team)
This question asks about how SBR replication works in MySQL. SBR stands for Statement-Based Replication.Let's break down the options:
* Option A: Statement based - This is the correct answer. SBR replication copies SQL statements from the master server to the slave server. The slave server executes these statements to keep its data in sync with the master server.
* Option B: Row based - This refers to Row-Based Replication (RBR), a different type of replication in MySQL. RBR copies changes to individual rows, not entire statements.
* Option C: Column based - MySQL doesn't have a replication method that works solely on a column basis.
* Option D: Table based - There's no specific "table-based" replication in MySQL. Replication generally focuses on rows or statements.
In summary, SBR replication is Statement-Based Replication, which means it replicates SQL statements to keep the slave server synchronized with the master server.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion