Zend
200-530 · Question #14
You have created a table based on the following data: EmpID NUMBER (5) PRIMARY KEY EmpName VARCHAR2 (35) NOT NULL Salary NUMBER (9, 2) NOT NULL Commission NUMBER (4, 2) ManagerName VARCHAR2 (25)…
The correct answer is B. SELECT e.EmpName, m.ManagerName FROM Employees e INNER JOIN Employees m ON D. SELECT e.EmpName, m.ManagerName FROM Employees e, Employees m WHERE. Zend 200-530 Exam
Data Management and Protection
Question
You have created a table based on the following data: EmpID NUMBER (5) PRIMARY KEY EmpName VARCHAR2 (35) NOT NULL Salary NUMBER (9, 2) NOT NULL Commission NUMBER (4, 2) ManagerName VARCHAR2 (25) ManagerID NUMBER (5) Now, you want to 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.
Options
- ASELECT e.EmpName, m.ManagerName FROM Employees e SELF JOIN Employees m ON
- BSELECT e.EmpName, m.ManagerName FROM Employees e INNER JOIN Employees m ON
- CSELECT e.EmpName, m.ManagerName
- DSELECT e.EmpName, m.ManagerName FROM Employees e, Employees m WHERE
- EEmpID = m.ManagerID;
How the community answered
(33 responses)- A12% (4)
- B76% (25)
- C3% (1)
- E9% (3)
Explanation
Zend 200-530 Exam
Topics
#SQL#self join#inner join#table aliases
Community Discussion
No community discussion yet for this question.