PrepAway - Latest Free Exam Questions & Answers

Which of the following joins is used in this query?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Non-equijoin

B.
Outer join

C.
Equijoin

D.
Self join

Explanation:

One Comment on “Which of the following joins is used in this query?


Leave a Reply

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