Which of the following set operators can be used to make certain that only the rows returned by both queries are displayed in the results?
A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS

Question

​Which of the following set operators can be used to make certain that only the rows returned by both queries are displayed in the results?
A) ​UNION
B) ​UNION ALL
C) ​INTERSECT
D) ​MINUS

Quizplus · Accepted Answer

The INTERSECT operator returns only the common rows between two SELECT statements. It is used to make sure that only the rows returned by both queries are displayed in the results.

​Which of the Following Set Operators Can Be Used to Make

Which of the Following Set Operators Can Be Used to Make