Q3

MCQ1 mark, −0.33

Consider the following relation Cinema( $\textit{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)

Loading…