UTpaper

Free mock tests & test series

Question 60Asked in UGC NET Computer Science, June 2015 (Paper II & III, Selected Questions)

The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT _Name) Consider the following SQL query SELECT DEPT_Name for…

The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT _Name) Consider the following SQL query SELECT DEPT_Name for STUDENT where SEX = 'M' group by DEPT_Name having avg (Marks) > SELECT avg (Marks) STUDENT. It Returns the Name of the Department for which :
  1. AThe average marks of male students is more than the average marks of students in the same Department
  2. BThe average marks of male students is more than the average marks of students in the University
  3. CThe average marks of male students is more than the average marks of male students in the University
  4. DThe average marks of students is more than the average marks of male students in the University
Show answerHide answer

Correct answer: (B) The average marks of male students is more than the average marks of students in the University

Explanation

The average marks of male students is more than the average marks of student in the university.

From UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions)

This is question 60 of UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.