Open In App
Related Articles

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

Improve Article
Save Article
Like 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

Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Last Updated : 03 Nov, 2021
Like Article
Save Article
Similar Reads