NIELIT 2017 July Scientist B (IT) - Section B: 54

Question

Cross Product is a

• A. Unary Operator
• B. Ternary Operator
• C. Binary Operator
• D. Not an operator

Answer 1

The CARTESIAN JOIN is also known as CROSS JOIN. In a CARTESIAN JOIN there is a join for each row of one table to every row of another table. 

So its a binary operator.

Hence C is correct.

Ref: https://www.geeksforgeeks.org/sql-join-cartesian-join-self-join/