Question

We have two tables,

Answer 1

Answer:

7 Columns, 50 Rows

Explanation:

Given

Table 1

$Columns = 5$

$Rows = 10$

Table 2

$Columns = 2$

$Rows = 5$

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:

$Rows = Row_1 * Row_2$

So, we have:

$Rows = 10 * 5$

$Rows = 50$

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

$Columns = Column_1 + Column_2$

So, we have:

$Columns = 5 + 2$

$Columns = 7$