A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. 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)
Answer:WHERE P1. Capacity> = All (select P2. Capacity from Cinema P2)
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: