Consider the following example.
Example:
A University name BITS has maintained the two relations to store the information about the faculty table and Teaches table. The faculty table stores the faculty_id (faculty_id has the unique id of faculty in the whole university) and faculty_name. The Teaches table stores the Course_id, Course_Name, and faculty_id. So the university admin department prints the faculty_name and Course_Name.
Query:
Select faculty_name
From faculty, Teaches
Where faculty.faculty_id =Teaches.faculty_id and
Course_Name='Database';
Which of the following option is true for the given query?
1
Prints the faculty name who teaches all courses.
2
Prints the faculty name who teaches other than Course name Database.
3
Prints the faculty name who teaches not Course name Database.
4
Prints the faculty name who teaches the Course name Database.
5
Question Not Attempted