MCQOPTIONS
Saved Bookmarks
| 1. |
The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT_Name)Consider the following SQL Query SELECT DEPT_Name from STUDENT where SEX = 'M' group by DEPT_Name having avg (Marks)>SELECT avg (Marks) from STUDENT. It returns the Name of the Department for which: |
| A. | The Average marks of Male students is more than the average marks of students in the same Department |
| B. | The average marks of male students is more than the average marks of students in the University |
| C. | The average marks of male students is more than the average marks of male students in the University |
| D. | The average marks of students is more than the average marks of male students in the University |
| Answer» C. The average marks of male students is more than the average marks of male students in the University | |