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
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
- Constituent Relationship Management (CRM) systems in e-Governance focus on
- To support repeated authentication and session management in web applications, what does the server typically send to the client?
- Which statement regarding address translation in paging and segmentation is NOT correct?
- NoSQL database management systems emerged primarily to address the limitations of conventional relational database architectures in environments characterized by evolving data structures, substantial data volumes and rapidly changing scalability requirements. Which of the following data-management scenarios most appropriately represents their principal intended application?
- COBIT-5 framework is associated with
- Which of the following security services are collectively ensured through the application of cryptographic techniques in secure communication systems?
- Consider a computer system with 128 MB of physical memory and a 32-bit virtual address space. If the page size is 2 KB and each page-table entry occupies 2 bytes, then what is the size of the page table?
- NoSQL database management systems are designed to accommodate diverse data representations and evolving application requirements, often without enforcing the rigid tabular structures associated with traditional relational database models. Which of the following characteristics most accurately reflects this architectural flexibility?