Question

Consider the following relation table: 

table(theatre, address capacity) 

What should be written at the end of this query 

Select P₁.address 

From table P₁ 

Such that it returns the theatre with maximum capacity?

(A) Where capacity > = ALL( select P₂.capacity from table p₂) 

(B) Where capacity > = ANY( select P₂.capacity from table p₂) 

(C) Where capacity > ALL( select P₂.capacity from table p₂) 

(D) Where capacity > ANY( select P₂.capacity from table p₂)

Answer 1

(A) Where capacity > = ALL( select P₂.capacity from table p₂) 

Inner query collects capacities of all the theatres and in outer query we are filterin the tuples with the condition “capaicty > = All”. So the theatres which are having maximum capacity will be satisfy the conductivity and they will.