Assume You Are Using the INTERSECT Operator to Combine the Results

question 69

Multiple Choice

Assume you are using the INTERSECT operator to combine the results from two tables with identical structure,CUSTOMER and CUSTOMER_2.The CUSTOMER table contains 10 rows,while the CUSTOMER_2 table contains 7 rows.Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table.How many records are returned when using the INTERSECT operator?

• A)0
• B)2
• C)7
• D)10