UGC NET CSE | Junet 2015 | Part 3 | Question: 8

go_editor asked Jul 31, 2016 • recategorized Oct 26, 2017 by Rishi yadav

3,093 views

2 votes

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

The average marks of Male students is more than the average marks of students in the department
The average marks of Male students is more than the average marks of students in the university
The average marks of students is more than the average marks of male students in the university
The average marks of Male students is more than the average marks of male students in the university

Databases
ugcnetcse-june2015-paper3
sql
databases

+ –

go_editor asked Jul 31, 2016 • recategorized Oct 26, 2017 by Rishi yadav

go_editor

3.1k views

See all

0 Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Best answer

3 votes

The average marks of Male students is more than the average marks of students in the university

B is ans

Prashant. answered Jul 31, 2016 • selected Oct 26, 2017 by Rishi yadav

Prashant.

See all

1 1 comment

abhinav kumar

commented Feb 7, 2020

Explain in detail plz

0 votes

Please log in or register to add a comment.

Voting & Accepting an answer helps improve the community

Answer:

← Previous Next →

← Previous in category Next in category →

Related questions

5 votes

1 answer

go_editor asked Jul 31, 2016

4,161 views

UGC NET CSE | Junet 2015 | Part 3 | Question: 11
The relation schemas $R_1$ and $R_2$ form a Lossless join decomposition of $R$ if and only if $R_1 \cap R_2 \twoheadrightarrow (R_1-R_2)$ $R_1 \rightarrow R_2$ $R_1 \cap R_2 \twoheadrightarrow (R_2-R_1)$ $R_2 \rightarrow R_1 \cap R_2$ $\text{i and ii}$ happen $\text{i and iv}$ happen $\text{i and iii}$ happen $\text{ii and iii}$ happen

The relation schemas $R_1$ and $R_2$ form a Lossless join decomposition of $R$ if and only if$R_1 \cap R_2 \twoheadrightarrow (R_1-R_2)$$R_1 \rightarrow R_2$$R_1 \cap R_2...

go_editor

4.2k views

go_editor asked Jul 31, 2016

Databases
ugcnetcse-june2015-paper3
databases
decomposition
database-normalization

+ –

4 votes

2 answers

go_editor asked Jul 31, 2016

3,353 views

UGC NET CSE | Junet 2015 | Part 3 | Question: 10
The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because Non_key attribute V_name is dependent on V_no which is part of composite key Non_key attribute V_name is dependent on Qty_sup Key attribute Qty_sup is dependent on primary key unit_price Key attribute V_ord_no is dependent on primary key unit_price

The RelationVendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF becauseNon_key attribute V_name is dependent on V_no which is part of composite keyNon_ke...

go_editor

3.4k views

go_editor asked Jul 31, 2016

Databases
ugcnetcse-june2015-paper3
databases
database-normalization

+ –

4 votes

4 answers

Shubham Sahu asked Jul 7, 2015

10,395 views

UGC NET CSE | Junet 2015 | Part 3 | Question: 7
Let $E_1$ and $E_2$ be two entities in E-R diagram with simple single valued attributes. $R_1$ and $R_2$ are two relationships between $E_1$ and $E_2$ where $R_1$ is one-many and $R_2$ is many-many. $R_1$ and $R_2$ ... attribute of their own. How many minimum number of tables are required to represent this situation in the Relational Model? 4 3 2 1

Let $E_1$ and $E_2$ be two entities in E-R diagram with simple single valued attributes. $R_1$ and $R_2$ are two relationships between $E_1$ and $E_2$ where $R_1$ is one-...

Shubham Sahu

10.4k views

Shubham Sahu asked Jul 7, 2015

Databases
databases
er-diagram
ugcnetcse-june2015-paper3

+ –

4 votes

1 answer

go_editor asked Aug 2, 2016

1,846 views

UGC NET CSE | Junet 2015 | Part 3 | Question: 75
The unix command: $ vi file1 file2 Edits file1 and stores the contents of file1 in file2 Both files i.e., file1 and file2 can be edited using 'ex' command to travel between the files Both files can be edited using 'mv' command to move between the files Edits file1 first, saves it and then edits file2

The unix command: $ vi file1 file2Edits file1 and stores the contents of file1 in file2Both files i.e., file1 and file2 can be edited using 'ex' command to travel between...

go_editor

1.8k views

go_editor asked Aug 2, 2016

Operating System
ugcnetcse-june2015-paper3
shell-script

+ –

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

0 reply

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

1 1 comment reply

Please log in or register to add a comment.

Related questions

0

1 1 comment