Question: How can we select the elements which have common Dept_name in both the relation ?
Options
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;
Database Freshers more questions
IS 1893-2002 gives details on:
The instrument which is used to measure the earthquake shaking....
Which of the following instruments is used to measure the....
The resistance of the soil with depth is measured by....
The_____ operation allows the combining of two relations by merging....
Which of the following command is used to display the....
The enable input is also known as ___________
Which among the following may not be achieved by using....
The sequence of DNA from where replication starts is called....
Shearing is also termed as ________________