In the context of relational database query processing and join operation algorithms, the merge join technique is commonly designated by which of the following alternative terminologies?
Asked in GPSC ICT Officer, Class-2 2026
Show answer
Answer: C. Sort-merge join algorithm, which utilizes the sorted ordering of join attributes to efficiently identify and combine corresponding tuples from the participating relations.
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
- Collaborative APIs under Digital India are primarily used for
- Internet-scale network management relies on a standardized framework. Which combination of protocols and components is used to perform this management effectively?
- Which of the following programming-language constructs in operating systems provides a synchronization mechanism that regulates concurrent access to shared resources and ensures that critical sections are accessed in a controlled manner?
- 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?
- 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?