SQL

Question 154

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 ?

A	the list of names of students with 100 marks in mathematics
B	the names of all students of all classes in which at least one student has 100 marks in mathematics
C	the names of all students in all classes having 100 marks in mathematics
D	the names and class of all students whose marks in mathematics is 100

Database-Management-SystemSQLUGC NET CS 2007-Dec-Paper-2

Question 154 Explanation:

Correct Answer: B

Question 154 Explanation:

Kirti

0 0 votes

Article Rating

0 Comments

Inline Feedbacks

View all comments