A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?A. select e.empid, d.head from emp e, dept d;B. select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;C. select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);D. select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;

  • Interview Candidate
  • 1
  • 6073

Showing Answers 1 - 1 of 1 Answers

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions