Consider the following relations: Student Roll No. Student Name 1 Raj 2 Rohit 3 Raj Roll No Course Marks 1 Math 80 1 English 70 2 Math 75 3 English 80 2 Physics 65 3 Math 80 Consider the following SQL query. 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 ________.

GATE Computer Science (CS) 2015 Shift 1 Solved Paper

Question : 61 of 65

Marks: +1, -0

Consider the following relations:

Student
Roll No.	Student Name
1	Raj
2	Rohit
3	Raj

Roll No	Course	Marks
1	Math	80
1	English	70
2	Math	75
3	English	80
2	Physics	65
3	Math	80

Consider the following SQL query.
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 ________.

Your Answer:

Validate

Go to Question:

Prev Question

Next Question