We have two tables, Table1 - 5 Columns, 10 Rows

Table2 - 2 Columns, 5 Rows

.

What will be the output of the following SQL query? SELECT * FROM Table1 CROSS JOIN Table2

O 7 Columns, 15 Rows

O 7 Columns, 50 Rows

O 10 Columns, 15 Rows

O 10 Columns, 50 Rows​

7 Columns, 50 Rows

Explanation:

Given

Table 1

Table 2

SQL join: Cross Join

Required

The number of rows and columns

In cross join, the number of rows that will be returned is calculated using:

So, we have:

Since all columns in both tables are selected, the new table will have the following  number of columns

So, we have:

answerapplication;