Databases · Relational Model and SQL
Official IIT answer key · IIT Roorkee · Audited Aug 2026
GATE CSE 2017 Set 2 Q46 · NAT · 2 marks
top_scorer.
Consider the following SQL query:
SELECT ta.player FROM top_scorer AS ta
WHERE ta.goals >ALL (SELECT tb.goals
FROM top_scorer AS tb
WHERE tb.country = 'Spain')
AND ta.goals >ANY (SELECT tc.goals
FROM top_scorer AS tc
WHERE tc.country = 'Germany')
The number of tuples returned by the above SQL query is ________.
Key concept
Topic notes
GATE tests the relational model across three interrelated formalisms: Relational Algebra (RA), Relational Calculus (TRC/DRC), and SQL. Questions evaluate core semantic equivalences, translation between declarative calculi and algebraic operators, table instance tracing (such as joins, group-by aggregations, and division), and corner cases like SQL three-valued logic, duplicate preservation, and safe TRC expressions.
Full Relational Model and SQL guide →Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.