To pefom a UNION, the two result sets must meet cetain requirements. The first citeia is that the two queies must use the same. A tables B number of tables C number of fields in the Select statement D number of JOINs in the Where statement

2. UNION ALL includes duplicate rows in the result set. A True B False

3. For a Union of two tables, what column name is typically assigned to the result set? A The column names from the first select statement in the UNION. B The column names from the second statement in the UNION. 4. Looking at the tables on page 352. If I am listing customers and the bikes they ordered with vendors and the bikes they sell. When I create a UNION quey, what happens if a customer purchased more than one of the same bike. A UNION eliminates duplicates B Need to use Distinct in the Select statement to eliminate duplicates. C Duplicates will be in the result set 5. To sot a UNION quey, you add the ORDER by statement. A several times at the end of each quey B once at the end of the UNION quey

6. With the ORDER by listed once at the end of the quey, what column names are assigned to the result set? A the column names of the first quey B the column names of the last quey C blank column names D combination of the first quey and last quey columns