Database-Management-System
October 4, 2023Software-process-models
October 4, 2023SQL
|
Question 40
|
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 _________.
|
2
|
|
|
3
|
|
|
4
|
|
|
5
|
Question 40 Explanation:
Output table is

Correct Answer: A
Question 40 Explanation:
Output table is

