0
0
DBMS Theoryknowledge~10 mins

Replication strategies in DBMS Theory - Interactive Code Practice

Choose your learning style9 modes available
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the code to identify the replication type where data is copied from one primary server to multiple secondary servers.

DBMS Theory
Replication type where data flows from one primary to many secondary servers is called [1] replication.
Drag options to blanks, or click blank then click option'
APeer-to-peer
BMaster-slave
CMulti-master
DSnapshot
Attempts:
3 left
💡 Hint
Common Mistakes
Confusing master-slave with peer-to-peer replication.
Thinking multi-master means one primary server.
2fill in blank
medium

Complete the sentence to describe the replication strategy where all nodes can accept writes and synchronize with each other.

DBMS Theory
In [1] replication, multiple servers act as equals and can all accept write operations.
Drag options to blanks, or click blank then click option'
ASnapshot
BLog shipping
CMulti-master
DMaster-slave
Attempts:
3 left
💡 Hint
Common Mistakes
Choosing master-slave which only allows one write server.
Confusing snapshot with multi-master replication.
3fill in blank
hard

Fix the error in the description of replication where data is copied at specific points in time.

DBMS Theory
Replication that copies data at specific intervals is called [1] replication.
Drag options to blanks, or click blank then click option'
ASnapshot
BTransactional
CSynchronous
DAsynchronous
Attempts:
3 left
💡 Hint
Common Mistakes
Confusing snapshot with transactional replication.
Mixing synchronous and asynchronous replication types.
4fill in blank
hard

Fill both blanks to complete the description of replication types based on timing.

DBMS Theory
In [1] replication, changes are applied immediately, while in [2] replication, changes are delayed.
Drag options to blanks, or click blank then click option'
ASynchronous
BAsynchronous
CSnapshot
DTransactional
Attempts:
3 left
💡 Hint
Common Mistakes
Mixing up synchronous and asynchronous terms.
Choosing snapshot or transactional which are different concepts.
5fill in blank
hard

Fill all three blanks to complete the dictionary that maps replication types to their main characteristics.

DBMS Theory
replication_info = {'Master-slave': '[1]', 'Multi-master': '[2]', 'Snapshot': '[3]'}
Drag options to blanks, or click blank then click option'
ASingle primary server
BMultiple write servers
CData copied at intervals
DReal-time synchronization
Attempts:
3 left
💡 Hint
Common Mistakes
Mixing characteristics between replication types.
Choosing 'Real-time synchronization' for snapshot replication.