PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements can you use to accomplish this?

You have created a table based on the following data:
<code>
EmpID NUMBER (5) PRIMARY KEYEmpName VARCHAR2 (35) NOT NULL Salary NUMBER (9,
2) NOT NULL CommissionNUMBER (4, 2) ManagerName VARCHAR2 (25) ManagerID NUMBER (5)
</code>
Now, you wantto display the names of employees and their managers, using a self join.
Which of the following SQL statements can you use to accomplish this? Each correct answer
represents a complete solution. Choose two.

PrepAway - Latest Free Exam Questions & Answers

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

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

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

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


Leave a Reply

Your email address will not be published. Required fields are marked *