Consider the set of relations shown below and the SQL query that follows.…

PYQ 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?

  1. A.

    Names of students who have got an A grade in all courses taught by Korth

  2. B.

    Names of students who have got an A grade in all courses

  3. C.

    Names of students who have got an A grade in at least one of the courses taught by Korth

  4. D.

    None of the above

Attempted by 598 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…