Database Fundamentals — Question 87

You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName

FROM Employee, Department -
This type of operation is called a/an:

Answer options

• A. Intersection
• B. Outer join
• C. Equi-join
• D. Cartesian product

Correct answer: D

Explanation

The correct answer is D, Cartesian product, because the query combines all rows from both the Employee and Department tables without any join condition. The other options, such as Intersection, Outer join, and Equi-join, require specific conditions or keys to relate the tables, which are not present in this statement.