The SQL produces the Cartesian product of the two tables. The number of elements in the Cartesian product is the number of rows of X multiplied by the number of rows of Y. The Cardinality is the number of rows.
The SQL produces the Cartesian product of the two tables. The number of elements in the Cartesian product is the number of rows of X multiplied by the number of rows of Y. The Cardinality is the number of rows.
The SQL produces the Cartesian product of the two tables. The number of elements in the Cartesian product is the number of rows of X multiplied by the number of rows of Y. The Cardinality is the number of rows.
The SQL produces the Cartesian product of the two tables. The number of elements in the Cartesian product is the number of rows of X multiplied by the number of rows of Y. The Cardinality is the number of rows.
The SQL produces the Cartesian product of the two tables. The number of elements in the Cartesian product is the number of rows of X multiplied by the number of rows of Y. The Cardinality is the number of rows.
There are two relations X and Y. Relation X has arity 1 and cardinality 2, relation Y has arity 3 and cardinality 4. Indicate the result of the SQL statement SELECT COUNT(*) FROM X,Y.
4
6
8
Cannot be calculated from the information given
None of the above.
| ||||
| ||||
|