What is true about these queries ?
select Lname, Fname
From employee E, dependent D
where E.Eno = D.Eno and E.Fname = D.Dep_name
Select Lname,Fname
from employee E
where exists (Select * from dependent D where E.Eno = D.Eno and E.Fname = D.Dep_name)
1
Both the queries are same
2
Both are different
3
Both the queries are same but first one is less complex than second one
4
Both the queries are same but first one is more complex than second one
5
Question Not Attempted