Gate CS-2015-1 Question Paper With Solutions

Q. 37 Consider the following relations :

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

The number of rows that will be returned by the SQL query is _________

(A) 0

(B) 1

(C) 2

(D) 3

Answer: (C)

Explanation: