Which of the following characteristics does NOT constitute one of the four fundamental ACID properties that govern transaction processing and ensure the reliability and integrity of operations within a database management system?
Asked in GPSC ICT Officer, Class-2 2026
Show answer
Answer: D. Replication, which involves maintaining multiple copies of data across different storage locations or database instances to enhance availability and fault tolerance.
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
- With reference to the application of Electronic Data Interchange (EDI) in digital business operations and inter-organisational information systems, which of the following statements most accurately characterises its principal functionality and operational significance? I. Facilitating the computer-to-computer transmission of standardised, structured business documents between independent organisations. II. Enabling the automated exchange of transaction-related records, such as purchase orders, invoices and dispatch notifications, in predefined electronic formats. III. Primarily providing an interactive communication environment for social networking and informal interpersonal exchanges. IV. Functioning exclusively as an electronic payment mechanism for transferring monetary value between participating entities. Select the correct answer using the codes given below:
- What is the primary function of a caching proxy server in a client-server architecture?
- Which of the following strategies can be employed in operating systems to prevent deadlock by ensuring that at least one of the necessary conditions for deadlock occurrence is eliminated?
- 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?
- 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?