Computer Science · Database Management System
Student data in a college is maintained in table Student(rollno, name, sex, mark, deptname). Given the SQL query: SELECT deptname FROM student WHERE sex = 'F' GROUP BY deptname HAVING AVG(mark) > (SELECT AVG(mark) FROM student); The query returns department names where:
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1the average mark of female students is less than that of all students.
- 2the average mark of female students is greater than the average mark of all female students.
- 3the average mark of female students is greater than the average mark of all students in the same department.
- 4the average mark of female students is greater than the average mark of all students.✓
Correct answer
the average mark of female students is greater than the average mark of all students.
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Database Management System MCQs →Want more practice questions on Database Management System?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management System