The given Query can also be replaced with SELECT name course id FROM instructor teaches nb...........

Computer GK DBMS

The given Query can also be replaced with_______:

SELECT name, course_id

FROM instructor, teaches

WHERE instructor_ID= teaches_ID;

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select name, course_id from instructor natural join teaches;

Select name, course_id from instructor;

Select course_id from instructor join teaches;

Answer: B
Join clause joins two tables by matching the common column

Submit Error