This Query can be replaced by which one of the following? SELECT name, course_id FROM instructor, te…

B. Select name, course_id from instructor natural join teaches;. Explanation: Join clause joins two tables by matching the common column.

Question #1045 of 749+ in Database Management System

📝 Question #1045

This Query can be replaced by which one of the following? SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

⌨️ Press A B C D to select

✓

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

B Select name, course_id from instructor natural join teaches; Correct

C Select name, course_id from instructor;

D Select course_id from instructor join teaches;

📚 Want More?

749+ questions with detailed answers