Celina works as a Database Administrator for Tech Mart Inc. The company uses an Oracle
database. The database contains a table named Employees. Following is the structure of the table:
<code>
EmpID NUMBER (5) PRIMARY KEY EmpName VARCHAR2 (35) NOT NULLSalary NUMBER (9,
2) NOT NULL Commission NUMBER (4, 2) ManagerNameVARCHAR2 (25) ManagerID NUMBER (5)
</code>
Celina wants to display the names of employees and their managers, using a self join.
Which of the following SQL statements will she use to accomplish this? Each correct answer
represents a complete solution. Choose two.

A.
SELECT e.EmpName, m.ManagerName
FROM Employees e, Employeesm
WHERE e.EmpID = m.ManagerID;

B.
SELECT e.EmpName, m.ManagerName
FROM Employees e INNER JOIN Employeesm
ON e.EmpID = m.ManagerID;

C.
SELECT e.EmpName, m.ManagerName
FROM Employees e LEFT OUTER JOIN Employees m
ON e.EmpID = m.ManagerID;

D.
SELECT e.EmpName, m.ManagerName
FROM Employees e SELF JOIN Employeesm
ON e.EmpID = m.ManagerID;