In distributed database transaction management, th...
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state
GPSC Prelims previous year questions

In distributed database transaction management, the conventional two-phase commit (2PC) protocol may leave participating processes in a blocked state when the coordinator fails before the final transaction decision is communicated. Which of the following protocols introduces an additional phase to mitigate this blocking problem and improve transaction termination under failure conditions?

Asked in GPSC ICT Officer, Class-2 2026

  1. Two-phase locking protocol, which regulates concurrent access to data items through the controlled acquisition and release of locks.
  2. Timestamp-based concurrency control protocol, which determines the permissible execution order of transactions using their assigned timestamps.
  3. Three-phase commit protocol, which incorporates an additional pre-commit phase to reduce the likelihood of indefinite blocking during coordinator failures.
  4. Validation-based concurrency control protocol, which determines whether a transaction can be committed by verifying its read and write sets before final execution.
Show answer

Answer: C. Three-phase commit protocol, which incorporates an additional pre-commit phase to reduce the likelihood of indefinite blocking during coordinator failures.

This previous-year question came without the commission's answer key; the answer was checked by AI. Always confirm with the official key.

More GPSC Prelims previous year questions questions

All 18,593 GPSC Prelims previous year questions questions →