Question

If no WHERE clause is used along with a __?__ join, it produces a result set containing the number of rows in a first table multiplied by the number of rows in the second table (also known as the Cartesian product). ?

LEFT,

RIGHT,

INNER,

OUTER,

CROSS,

PARALLEL)

Answer 1

ANSWER:  CROSS

EXPLANATION:

Consider this table (Customers)

Consider other table (Categories)

Now we cross join using the query

SELECT *
FROM Customers
CROSS JOIN Categories;

RESULT:

*******************

Please give an Upvote if you found this answer helpful

******************