GATE 1996
October 4, 2023SQL
October 4, 2023SQL
|
Question 15
|
Consider the set of relations shown below and the SQL query that follows.
Students: (Roll_number, Name, Date_of_birth)
Courses: (Course number, Course_name, Instructor)
Grades: (Roll_number, Course_number, Grade)
select distinct Name
from Students, Courses, Grades
where Students. Roll_number = Grades.Roll_number
and Courses.Instructor = Korth
and Courses.Course_number = Grades.Course_number
and Grades.grade = A
Which of the following sets is computed by the above query?
|
Names of students who have got an A grade in all courses taught by Korth
|
|
|
Names of students who have got an A grade in all courses
|
|
|
Names of students who have got an A grade in at least one of the courses taught by Korth
|
|
|
in none of the above
|
Question 15 Explanation:
The query results a names of students who got an A grade in at least one of the courses taught by korth.
Correct Answer: C
Question 15 Explanation:
The query results a names of students who got an A grade in at least one of the courses taught by korth.
