GATE CS and IT 2015 Paper
© examsnet.com
Question : 61
Total: 65
Consider the following relations:
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 _____________.
| Student | |
|---|---|
| Roll_No | Student_Name |
| 1 | Raj |
| 2 | Rohit |
| 3 | Raj |
| Performance | ||
|---|---|---|
| Roll_No | Course | Marks |
| 1 | Math | 80 |
| 1 | English | 70 |
| 2 | Math | 75 |
| 3 | English | 80 |
| 2 | Physics | 65 |
| 3 | Math | 80 |
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:
Go to Question: