The Intersection of a table of N rows and of a table of M rows (M

Question

The Intersection of a table of N rows and of a table of M rows (M<=N)has the following number of rows:
A) M+N
B) A number in the range N to M+N
C) N
D) A number in the range 0 to M

Quizplus · Accepted Answer

The intersection of two tables refers to the set of rows that are common to both tables. In the best-case scenario, every row in the smaller table (M rows) matches a row in the larger table (N rows), resulting in M common rows. In the worst case, there are no common rows, resulting in 0 common rows. Therefore, the number of rows in the intersection can range from 0 to M.

The Intersection of a Table of N Rows and of a Table