Databases · SQL

Official IIT answer key · IIT Delhi · Audited Aug 2026

GATE CSE 2012 Q51 · MCQ · 2 marks

Common Data for Questions 50 and 51: Consider the following relations $A$ , $B$ and $C$ : How many tuples does the result of the following SQL query contain? `SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')`

Select an option to check

Key concept

SQL

Step-by-step verified solution

Examiner trap & misconception

Topic notes

How GATE tests SQL

In GATE CS, SQL is tested through a balanced mix of declarative query semantics, relational-algebra correspondence, subquery evaluation (correlated, nested, and universal quantification), and instance-level tracing. Questions range from conceptual integrity rules (DDL constraints, FOREIGN KEY targets, GROUP BY/HAVING rules) to practical computation of output row counts and aggregate values on small database instances. Recent papers strongly emphasize NAT execution traces and multi-correct (MSQ) equivalent query formulations.

Full SQL guide →

More on SQL

All 17 questions on SQL →

Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.

Databases · SQL

Official IIT answer key · IIT Delhi · Audited Aug 2026

Take topic test

GATE CSE 2012 Q51 · MCQ · 2 marks

Common Data for Questions 50 and 51: Consider the following relations $A$ , $B$ and $C$ : How many tuples does the result of the following SQL query contain? `SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')`

Select an option to check

Key concept

SQL

Step-by-step verified solution

Examiner trap & misconception

Topic notes

How GATE tests SQL

Full SQL guide →

More on SQL

All 17 questions on SQL →

Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.

Common Data for Questions 50 and 51: Consider the following relations $A$ , $B$ and $C$ : How many tuples does the result of the following SQL query contain? `SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')`

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2012

More on SQL

Common Data for Questions 50 and 51: Consider the following relations $A$ , $B$ and $C$ : How many tuples does the result of the following SQL query contain? `SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')`

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2012

More on SQL

Common Data for Questions 50 and 51: Consider the following relations AAA, BBB and CCC: How many tuples does the result of the following SQL query contain? SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2012

More on SQL

Share this solution

Common Data for Questions 50 and 51: Consider the following relations AAA, BBB and CCC: How many tuples does the result of the following SQL query contain? SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2012

More on SQL

Share this solution

Common Data for Questions 50 and 51: Consider the following relations $A$ , $B$ and $C$ : How many tuples does the result of the following SQL query contain? `SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')`

Common Data for Questions 50 and 51: Consider the following relations $A$ , $B$ and $C$ : How many tuples does the result of the following SQL query contain? `SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')`