Gate CS-2019 Question Paper With Solutions

Q. 61 A relational database contains two tables Student and Performance as shown below:

 

The primary key of the Student table is Roll_no. For the Performance table, the columns Roll_no. and Subject_code together from the primary key. Consider the SQL query given below:

SELECT S.Student_name, sum(P.Marks)
FROM Student S, Performance P
WHERE  P.Marks  >  84
GROUP BY S.Student_name;

The number of rows returned by the above SQL query is _________ .

Note: This was Numerical Type question.

(A) 5

(B) 4

(C) 3

(D) None of these.

Answer: (A)

Explanation:

Learn More:   Gate ME-2017-1 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here