The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.
A)union
B)intersect
C)intersection
D)difference

Question

The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.​
A)union
B)​intersect
C)intersection
D)​difference

Quizplus · Accepted Answer

The difference of two tables returns only those records from the first table that do not exist in the second table. Therefore, option D is the correct answer. The union is a combination of records from two tables, intersect returns only the records that exist in both tables, and intersection is not a valid SQL operation.

The ____ of Two Tables Is the Set of All