Question

If table A has M rows and table B has N rows (M>N), which of the following statements is correct?

A. the resulting table of a union has a number in the range 0 to M+N.
B. the resulting table of A ( M rows) difference B ( N rows) has a number in the range 1 to 1.
C. the resulting table of a natural join has a number in the range M to M.
D. the resulting table of a natural join has a number in the range 0 to M∗N.

Answer 1

The resulting table of a union of table A and table B has a number of rows ranging from 0 to M+N.

Step-by-step explanation:

In the given scenario, table A has M rows and table B has N rows where M > N. In this case, the resulting table of a union of A and B will have a number of rows ranging from 0 to M+N. So, the correct statement is A.