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;