quiz 4

1. Set operations in SQL allow you to perform operations on _______________ sets of data.

2. The _______________ operator combines the results of two or more SELECT statements into a single result set

3. The _______________ operator returns only the unique rows from two or more result sets.

4. The _______________ operator returns rows that exist in both of two result sets.

5. The _______________ operator returns rows from one result set that do not exist in another.

6. When using the UNION operator, you can specify whether to include _______________ rows.

7. The _______________ operator is used to combine rows from two or more result sets without removing duplicates.

8. A _______________ is a condition that specifies how two tables should be combined in a join operation.

9. The _______________ join returns only the rows that have matching values in both tables being joined.

10. In an SQL join, the columns used for joining are often referred to as _______________.