Question

What are the maximum and minimum number of rows returned by the R1 right outer join R2?
a. Min = rows in R2, max = rows in RI * rows in R2
b. Min=0, max = rows in R1 + rows in R2
c. Min = 0, max = (rows in RI + rows in R2) - 1
d. Min = rows in R2, max = (rows in R1 + rows in R2)-1
Answer
СА
OB
Ос
D​

Answer 1

The maximum and the minimum number of rows returned by the R1 right outer join R2 are: Min = rows in R2, Max = (rows in R1 + rows in R2) - 1 (Option D)

Explanation:

'Right Outer Join' on tables T1, and T2 shows the impact of generating a table that holds the matching records from both the tables + the complete data of right hand or second table.

Let us say that the Table1 contains 20 records and Table2 contains 30 records.

Minimum Records:

On taken condition, if there is no matching records between both the tables, or, all the records on the Table2 are unique, we will get the minimum number of rows, i.e., 30 rows.

So, Minumum Rows = Rows in Table2 (R2)

Maximum Records:

On taken condition, if there is all the records of Table1 is matching with a single record from table2, then we will get the total rows as Total rows in Table 1 + (Total rows in Table2 - 1) because, 1 record is deducted as it matches with all the records of Table1. So, the total will be 20+30-1 = 49.

So, Maximum Rows = (Rows in Table1 (R1) + Rows in Table2(R2)) - 1

Learn more:

1. Noisy values are the values that are valid for the dataset, but are incorrectly recorded. Is it?

brainly.in/question/6658996

2. What is linked list in data structure?

https://brainly.in/question/6964440

Answer 2

Explanation:

d.Min = rows in R2, max = (rows in R1 + rows in R2)-1