There are two tables, customer table has 5 rows and the order table has 8 rows. How many will be generated when the following query is executed against the database :-

select *
from tbl_customer, tbl_order;

40 rows will be generated because it simply cross product the table(there is no where condition here). So for each row of the customer table, there will be 8 rows associated from the order table.

That is, 5 * 8 = 40 rows


Thanks and Regards
Akiii