In order for two queries to be UNION-compatible,they must:
A) both have the same number of lines in their SQL statements.
B) both output compatible data types for each column and return the same number of rows.
C) both return at least one row.
D) all of the above.

Question

Quizplus · Accepted Answer

For two queries to be UNION-compatible, they must have the same number of columns and compatible data types for each column. They do not necessarily have to return the same number of rows or have at least one row returned, as a query may return an empty result set but still be UNION-compatible. Therefore, option B is the best choice as it correctly states the requirements for UNION-compatible queries.

In Order for Two Queries to Be UNION-Compatible,they Must