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;
B. Select Dept name from instructor ,Course ;
C. Select * from instructor i , course c ;
D. Select Dept_name from instructor where Dept_name = NULL;
Answer:A
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; B. Select Dept name from instructor ,Course ; C. Select * from instructor i , course c ; D. Select Dept_name from instructor where Dept_name = NULL;
Explanation:Here only the common elements are displayed .