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

Question

Quizplus · Accepted Answer

The INTERSECT operator returns only the common rows in both tables. Since both tables have the identical structure, it will return only the rows that match in both tables. As Dunne and Olowski are present in both tables, so two rows will be returned. Thus, the answer is B.

Assume You Are Using the INTERSECT Operator to Combine the Results