____ yields only the rows that appear in both tables.
A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT

Question

Quizplus · Accepted Answer

INTERSECT is the SQL operation used to obtain the intersection of two SELECT statements. It returns only the rows that appear in both SELECT statements. Therefore, A) INTERSECT is the best choice for the given problem. B) UNION will return all the rows from both tables, C) DIFFERENCE will return only the rows that appear in one table but not the other, and D) SELECT is not an operation, but a keyword used to specify the columns to be returned from a query.

____ Yields Only the Rows That Appear in Both Tables