...
Operating-Systems
October 4, 2023
SQL
October 4, 2023
Operating-Systems
October 4, 2023
SQL
October 4, 2023

SQL

Question 15

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
in none of the above
Question 15 Explanation: 
The query results a names of students who got an A grade in at least one of the courses taught by korth.
Correct Answer: C
Question 15 Explanation: 
The query results a names of students who got an A grade in at least one of the courses taught by korth.
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!