Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query SELECT P1.address FROM Cinema P1 such that it always finds the addresses of theaters with maximum capacity? A) WHERE P1.capacity >= All (select P2.capacity from Cinema P2) B) WHERE P1.capacity >= Any (select P2.capacity from Cinema P2) C) WHERE P1.capacity > All (select max(P2.capacity) from Cinema P2) D) WHERE P1.capacity > Any (select max(P2.capacity) from Cinema P2)

Official answer: A) WHERE P1.capacity >= All (select P2.capacity from Cinema P2). Explanation: To find the addresses of the theater(s) having the maximum capacity, we want to select every tuple P1 whose capacity is greater than or equal to the capacity of all tuples P2 in the relation `Cinema` [1]. - Option A: `WHERE P1.capacity >= All (select P2.capacity from Cinema P2)` checks that P1.capacity x for every capacity x in `Cinema` [1]. This correctly selects the theaters with maximum capacity [1]. - Option B: `>= Any` selects any theater whose capacity is greater than or equal to *at least one* theater's capacity (i.e., any capacity minimum capacity) [1]. - Option C: `> All (select max(P2.capacity) ...)` searches for a capacity strictly greater than the maximum capacity, which returns an empty result [1]. - Option D: `> Any (select max(P2.capacity) ...)` is also strictly greater than the maximum, returning nothing [1]. Thus, (A) is the correct option [1].

A) WHERE P1.capacity >= All (select P2.capacity from Cinema P2)

B) WHERE P1.capacity >= Any (select P2.capacity from Cinema P2)

C) WHERE P1.capacity > All (select max(P2.capacity) from Cinema P2)

D) WHERE P1.capacity > Any (select max(P2.capacity) from Cinema P2)

Databases · SQL

Official IIT answer key · IIT Kanpur · Audited Aug 2026

Take topic test

GATE CSE 2015 Set 3 Q3 · MCQ · 1 mark

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query `SELECT P1.address FROM Cinema P1` such that it always finds the addresses of theaters with maximum capacity?

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 Kanpur · Audited Aug 2026

Take topic test

GATE CSE 2015 Set 3 Q3 · MCQ · 1 mark

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query `SELECT P1.address FROM Cinema P1` such that it always finds the addresses of theaters with maximum capacity?

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.

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query `SELECT P1.address FROM Cinema P1` such that it always finds the addresses of theaters with maximum capacity?

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2015 Set 3

More on SQL

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query `SELECT P1.address FROM Cinema P1` such that it always finds the addresses of theaters with maximum capacity?

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2015 Set 3

More on SQL

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query SELECT P1.address FROM Cinema P1 such that it always finds the addresses of theaters with maximum capacity?

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2015 Set 3

More on SQL

Share this solution

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query SELECT P1.address FROM Cinema P1 such that it always finds the addresses of theaters with maximum capacity?

Step-by-step verified solution

Check you can still solve SQL under a clock

More from GATE CSE 2015 Set 3

More on SQL

Share this solution

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query `SELECT P1.address FROM Cinema P1` such that it always finds the addresses of theaters with maximum capacity?

Consider the following relation Cinema(theater, address, capacity) Which of the following options will be needed at the end of the SQL query `SELECT P1.address FROM Cinema P1` such that it always finds the addresses of theaters with maximum capacity?