Let a table Student has 10 records and Stream has 3 records, then how many rows we will get by using below query:Select * from Student, StreamA3B10C13D30

1. ### Break Down the Problem

We need to determine how many rows will result from a Cartesian product of the two tables, Student and Stream. We have:

• 10 records in the Student table.
• 3 records in the Stream table.

2. ### Relevant Concepts

The concept of Cartesian product in databases states that when two tables are joined without a specified condition, each row from the first table is paired with each row from the second table. This results in the total number of rows being the product of the number of rows in each table.

3. ### Analysis and Detail

Let:

• $R_1$ = Number of records in the Student table = 10
• $R_2$ = Number of records in the Stream table = 3

The total number of rows resulting from the query can be calculated as: $R = R_1 \times R_2 = 10 \times 3 = 30$

4. ### Verify and Summarize

Based on the formula for the Cartesian product:

• Every record in the Student table will be combined with every record in the Stream table.
• Therefore, the calculation is confirmed as correct: $10 \times 3 = 30$.

Final Answer

The total number of rows returned by the query will be 30.