Assume you are using the MINUS 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 MINUS operator?
A)0
B)2
C)8
D)10

Question

Quizplus · Accepted Answer

The MINUS operator returns rows from the first table that are not present in the second table. Since Dunne and Olowski are present in both tables, they will be excluded from the result. Therefore, 10 - 2 = 8 records will be returned.

Assume You Are Using the MINUS Operator to Combine the Results