Multiple choice

What would be the query for enlisting the faculty member who does not teach any class using outer join?

Tables: Faculty(facid,facname,......) Student(stuid,stuname,.......) Class(facid,course,.......)

  1. select f.facid, f.facname from class c,faculty f where c.facid(+)=f.facid and c.course is null order by f.facname;

  2. select f.facid, f.facname from class c right join faculty f on c.facid(+)=f.facid where c.course is null order by f.facname;

  3. select f.facid, f.facname from class c,faculty f where c.facid(+)=f.facid(+) and c.course is null order by f.facname;

  4. select f.facid, f.facname from class c full join faculty f on c.facid=f.facid where c.course is null order by f.facname;

  5. all of the above

Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Option 5 is the correct answer, as the query can be written in all the given four ways.