____ combines all rows from two tables,excluding duplicate rows.
A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT

Question

Quizplus · Accepted Answer

The UNION operator combines all rows from two tables, excluding duplicate rows. It creates a result set that includes all the rows from both tables and eliminates any duplicate rows that exist in both tables. A is incorrect as INTERSECT combines only the common rows between two tables. C is incorrect as DIFFERENCE combines all the rows from the first table that are not present in the second table. D is incorrect as SELECT is not an operator to combine rows from two tables.

____ Combines All Rows from Two Tables,excluding Duplicate Rows