HP Exam Questions

Which queries will display all rows of data from the emp table?

Which queries will display all rows of data from the emp table? (Select two.)

A.
selectename, dname
fromemp natural left outer join dept;

B.
selectename, dname
fromemp natural right outer join dept;

C.
select ename, dname
fromemp left outer join emp using (deptno);

D.
selectename, dname
from emp left join dept on emp.deptno = dept.deptno
union
selectename, dname
form emp right join dept on emp.deptno = dept.deptno;