Zend
ZF-100-500 · Question #154
Angela works as a Database Administrator for AznoTech Inc. She writes the following query: SELECT Dept_Name, Emp_Name FROM Departments d1, Employees e1 WHERE d1.Dept_No = e1.Dept_No ORDER BY…
The correct answer is C. Equijoin. See the full explanation below for the reasoning.
Question
Angela works as a Database Administrator for AznoTech Inc. She writes the following query: SELECT Dept_Name, Emp_Name FROM Departments d1, Employees e1 WHERE d1.Dept_No = e1.Dept_No ORDER BY Dept_Name, Emp_Name; Which of the following joins is used in this query?
Options
- ANon-equijoin
- BOuter join
- CEquijoin
- DSelf join
How the community answered
(30 responses)- A10% (3)
- B7% (2)
- C80% (24)
- D3% (1)
Community Discussion
No community discussion yet for this question.