UGC-NET | UGC NET CS 2018 Dec – II | Question 26

Consider the following tables (relations) :

Primary keys in the tables are shown using Underline. Now, Consider the following query:

SELECT S.Name, Sum (P.Marks)
FROM Students S, Performance P
WHERE S.Roll-No = P.Roll-No
GROUP BY S.Name 

The number of rows returned by the above query is
(A) 3
(B) 2
(C) 0
(D) 1


Answer: (B)

Explanation: There are two groups by name : Ramesh and Mukesh. So, answer is 2.


Quiz of this Question

My Personal Notes arrow_drop_up
Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.