A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. 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
Answer:Names of students who have got an A grade in at least one of the courses taught by Korth
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: