In the context of relational database query proces...
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 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

  1. Nested-loop join algorithm, which evaluates tuple combinations through iterative comparison of records from the participating relations.
  2. Hash join algorithm, which employs a hash-based partitioning or lookup mechanism to identify matching tuples across relations.
  3. Sort-merge join algorithm, which utilizes the sorted ordering of join attributes to efficiently identify and combine corresponding tuples from the participating relations.
  4. Index join algorithm, which exploits an available index structure to locate matching records across the relations involved in the join operation.
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

All 18,593 GPSC Prelims previous year questions questions →