Home » MCQs » Oracle MCQs » Oracle Cross, Anti, and Semi Joins MCQs

A cross join has ____ rows when table1 and table2 have 'x' rows and 'y' rows, respectively

2. A cross join has ____ rows when table1 and table2 have "x" rows and "y" rows, respectively.

1. X+Y
2. X*Y
3. X/Y
4. X-Y

Answer: B) X*Y

Explanation:

A cross join has X*Y rows when table1 and table2 have "Y" rows and "Y" rows, respectively.