GATE DBMS PYQs | Problem 8 | Output of an SQL Query | GATE-2003

Описание: 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?
A. Names of students who have got an A grade in all courses taught by Korth
B. Names of students who have got an A grade in all courses
C. Names of students who have got an A grade in at least one of the courses taught by Korth
D. None of the above

For more GATE DBMS PYQs watch this playlist:    • GATE DBMS PYQs  

#GATE2025 #GATEPrep #GATEPYQ #DBMS #SQL #GATECSE #GATENotes #DatabaseQuestions #PreviousYearQuestions #GATESQL #SQLPractice #GATEDBMS #damn_engineering