Skip to content
Related Articles

Related Articles

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

View Discussion
Improve Article
Save Article
  • Last Updated : 03 Nov, 2021
View Discussion
Improve Article
Save Article

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

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
Recommended Articles
Page :

Start Your Coding Journey Now!