employee(eno,ename) works_on(eno,pno,ename) project(pno, project) select ename from employee where eno in(select eno from works_on where pno =(select *from project) what is the output ?

a)Employee who works on all project. b)Employee who works one project . c) name of employee who works on more than one project. d)Select ename from employee where salary = salary

• Ans: a
  the section of the query (Select eno from work_on where pno=(Select * from project) )defines the eno of employee working on all project
• 9 years agoHelpfull: Yes(4) No(0)
• Option a, Name of the employee who works on all projects. Because the innermost query will retrieve us all the project numbers.
• 9 years agoHelpfull: Yes(1) No(0)
• a is correct
• 7 years agoHelpfull: Yes(1) No(0)
• ans b) output is the name of the employee who work in one project
• 9 years agoHelpfull: Yes(0) No(3)