Consider the following tables: | PlayerID | PlayerName | |---|---| | 1 | Messi | | 2 | Muller | | 3 | Ronaldo | | 4 | Messi | | 5 | Ozil | | 6 | Ronaldo | Players Table | PlayerID | LeagueName | Goals | |---|---|---| | 1 | La Liga | 7 | | 2 | Premier League | 5 | | 3 | La Liga | 2 | | 1 | Champions League | 8 | | 2 | Bundesliga | 6 | | 1 | Copa del Rey | 5 | | 4 | La Liga | 4 | | 4 | Champions League | 3 | | 3 | Champions League | 1 | | 6 | La Liga | 3 | | 3 | Copa del Rey | 4 | | 6 | Champions League | 2 | Stats Table Consider the following SQL query. SELECT P.PlayerName, Sum(S.Goals) FROM Players Table P, Stats Table S WHERE P.PlayerID= S.PlayerID GROUP BY P.PlayerName The numbers of rows that will be returned by the SQL query is:

Database Management Systems · End Term · 31 Aug 2025 · May 2025 term

Question 15: Consider the following tables: | PlayerID | PlayerName |…

Question 15

+2 marksNumerical answer

Consider the following tables:

PlayerID	PlayerName
1	Messi
2	Muller
3	Ronaldo
4	Messi
5	Ozil
6	Ronaldo

Players Table

PlayerID	LeagueName	Goals
1	La Liga	7
2	Premier League	5
3	La Liga	2
1	Champions League	8
2	Bundesliga	6
1	Copa del Rey	5
4	La Liga	4
4	Champions League	3
3	Champions League	1
6	La Liga	3
3	Copa del Rey	4
6	Champions League	2

Stats Table

Consider the following SQL query.

sql

1SELECT P.PlayerName, Sum(S.Goals)
2FROM Players Table P, Stats Table S
3WHERE P.PlayerID= S.PlayerID
4GROUP BY P.PlayerName

The numbers of rows that will be returned by the SQL query is:

Show answer

Correct answer: 3

See the whole paper Take it as a mock test

Question 15 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 31 Aug 2025, in the May 2025 term (IIT M DIPLOMA FN EXAM QDD1 31 Aug 2025). It carries 2 marks.

Question 15: Consider the following tables: | PlayerID | PlayerName |…

Question 15

More questions from this paper