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: https://youtube.com/playlist?list=PLHV8V5iHbUHKBbXFAfctsndD2Nyd1mSSM&si=g7p7d-9kKME1gNrp

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

Видео GATE DBMS PYQs | Problem 8 | Output of an SQL Query | GATE-2003 канала damn_engineering