How can we select the elements which have common Dept_name in both the relation ?

A. Select * from instructor i , course c where i.Dept_name=c.Dept_name;. Explanation: Here only the common elements are displayed .

Question #1230 of 749+ in Database Management System

📝 Question #1230

⌨️ Press A B C D to select

✓

All Options & Correct Answer

A Select * from instructor i , course c where i.Dept_name=c.Dept_name; Correct

B Select Dept name from instructor ,Course ;

C Select * from instructor i , course c ;

D Select Dept_name from instructor where Dept_name = NULL;

📚 Want More?

749+ questions with detailed answers