Table A has 10 records, table B has 100 rows. The relationship between A and B is 1:N. What are the possible outcomes when joining the tables? The possible answers answers are (there may or may not be more than one):
100 rows, using A INNER JOIN B
10 records, using A LEFT JOIN B
10 records, using A RIGHT JOIN B
10 records, using A FULL OUTER JOIN B
100 records, using A FULL OUTER JOIN B
Minimal number of output rows is 10
Maximal number of output rows is 1000