Multiple ChoiceHard 45s
Two-phase commit blocking
Why is 2PC considered a blocking protocol with poor availability?
Options
- 1If the coordinator crashes after prepare, participants are blocked holding locks until it recovers
- 2It requires a quorum of clients online, so a client disconnecting mid-transaction blocks the coordinator
- 3It cannot handle more than two databases, so a transaction spanning three or more participants stalls
- 4It only works over UDP, so prepare and commit messages can be dropped, leaving participants unable to learn the outcome
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.