Register

UGC NET CSE | December 2007 | Part 2 | Question: 20

Redirected
• edited by
1,078 views
0 votes
0 votes

Consider the query :

SELECT student_name FROM students WHERE 
class_name=(SELECT class_name FROM students WHERE math_marks=100);

what will be the output ?

  1. the list of names of students with $100$ marks in mathematics

  2. the names of all students of all classes in which at least one student has $100$ marks in mathematics

  3. the names of all students in all classes having $100$ marks in mathematics

  4. the names and class of all students whose marks in mathematics is $100$

• edited by
User Avatar

2 Answers

0 votes
0 votes
A)the list of names of students with 100 marks in mathematics
User Avatar
0 votes
0 votes 
answer is B
“class_name=(SELECT class_name FROM students WHERE math_marks=100)”

Selecting classname of students who have scored 100 marks in maths , 
from a relation called student .




 “SELECT student_name FROM students WHERE class_name= “

Selecting student names from the student relation where there’s atleast 
1 student who has scored 100 marks in math..
So basically printing names of all students of a classname in which 
atleast 1 student has scored 100 marks in math .
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
go_editor asked Mar 28, 2020
813 views
UGC NET CSE | December 2007 | Part 2 | Question: 16
A primary key for an entity is : a candidate key any attribute a unique attribute a superkey
A primary key for an entity is :a candidate keyany attributea unique attributea superkey
User Avatar
0 votes
0 votes
1 answer
2
go_editor asked Mar 28, 2020
467 views
UGC NET CSE | December 2007 | Part 2 | Question: 17
Aggregate functions in SQL are : GREATEST, LEAST and ABS SUM, COUNT and AVG UPPER, LOWER and LENGTH SQRT, POWER and MOD
Aggregate functions in SQL are :GREATEST, LEAST and ABSSUM, COUNT and AVGUPPER, LOWER and LENGTHSQRT, POWER and MOD
User Avatar
0 votes
0 votes
1 answer
3
go_editor asked Mar 28, 2020
629 views
UGC NET CSE | December 2007 | Part 2 | Question: 19
The end of an SQL command is denoted by : an end-of-line character an ‘enter-key’ marker entering F4 key a semicolon (;)
The end of an SQL command is denoted by :an end-of-line characteran ‘enter-key’ markerentering F4 keya semicolon (;)
User Avatar
2 votes
2 votes
1 answer
4
go_editor asked Mar 28, 2020
1,089 views
UGC NET CSE | December 2007 | Part 2 | Question: 1
A box contains six red balls and four green balls. Four balls are selected at random from the box. What is the probability that two of the selected balls are red and two are green ? $\large\frac{3}{7}$ $\large\frac{4}{7}$ $\large\frac{5}{7}$ $\large\frac{6}{7}$
A box contains six red balls and four green balls. Four balls are selected at random from the box. What is the probability that two of the selected balls are red and two ...
User Avatar
Link Copied!