GATE CSE 2015 SET 3

Planning to take coaching on Unacademy http://bit.ly/gate_unacademy or https://unacademy.com/ here is a code for 10% off PLUS1BPK1 Telegram Notification Group link:- https://t.me/joinchat/X5egW_cvdt9kMGY1 Telegram discussion Group link:- https://t.me/joinchat/VCyGUmVq8RNkMzhl Downloads resources from here https://education4fun.com/gate-cse/ MCQ (Single Correct Answer) GATE CSE 2015 Set 3 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 GREATER THAN = All (select P2. Capacity from Cinema P2)(B) WHERE P1. Capacity GREATER THAN = Any (select P2. Capacity from Cinema P2)(C) WHERE P1. Capacity GREATER THAN All (select max(P2. Capacity) from Cinema P2)(D) WHERE P1. Capacity GREATER THAN Any (select max (P2. Capacity) from Cinema P2)