Gate CS-2003 Question Paper With Solutions

Q. 37 Consider the set of relations shown below and the SQL query that follow:

Students:(Roll_number,Name,Date_of_birth)
Courses:(Course_number,Course_name,Instructor)
Grades:(Roll_number,Course_number,Grade)
select distrinct Name
from Students, Courses, Grades
Where Students,Roll_number=Grades. Toll_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) Name of students who have got an A grade in at least one of the courses
taught by Korth

(D) None of the above

Answer: (C)

Explanation:

Gate CS-2003 Question Paper With Solutions

Learn More:   Gate EC-2010 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here