SQL

Single correct

• Athe selection operation in relational algebra
• Bthe selection operation in relational algebra, except that SELECT in SQL retains duplicates
• Cthe projection operation in relational algebra
• Dthe projection operation in relational algebra, except that SELECT in SQL retains duplicates

SELECT S.Student_Name, sum(P.Marks)
FROM Student S, Performance P
WHERE S.Roll_No = P.Roll_No
GROUP BY S.Student_Name

Numerical answer

SELECT P1.address
FROM Cinema P1

Single correct

• AWHERE P1.capacity >= All (select P2.capacity from Cinema P2)
• BWHERE P1.capacity >= Any (select P2.capacity from Cinema P2)
• CWHERE P1.capacity > All (select max(P2.capacity) from Cinema P2)
• DWHERE P1.capacity > Any (select max(P2.capacity) from Cinema P2)