Within the framework of concurrency control in a database management system, what aspect of transaction execution is formally governed by a locking protocol to ensure coordinated access to shared data resources and maintain transactional correctness?
Asked in GPSC ICT Officer, Class-2 2026
Show answer
Answer: B. The conditions and sequence of operations under which a transaction is permitted to acquire locks on, or release locks from specific data items during its execution.
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
- Enterprise Resource Planning (ERP) systems are primarily designed to
- Which of the following statements correctly describes the role of HTTP in internet communication?
- If one simple paging system has a 224 bytes of physical memory, 256 pages of logical address space and page size of 210 bytes, then how many entries are in the page table?
- 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?
- 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?