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.
- X+Y
- X*Y
- X/Y
- 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.