Home » MCQs » SQL MCQs » SQL SET Operators MCQs

A SELECT statement is intersected to use it as a join, but it only returns the records that are ________ between both statements

6. A SELECT statement is intersected to use it as a join, but it only returns the records that are ________ between both statements.

1. Distinct
2. Common
3. Shared
4. Both B and C

Answer: D) Both B and C

Explanation:

A SELECT statement is intersected to use as a join, but it only returns the records that are common or shared between both statements.