Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 8 of 91

JOINS and SET Operations — Question 8

Back to all questions
8
Question

Question 8

Assertion. The MINUS and INTERSECT operators are similar.

Reason. The MINUS operator returns only the rows from the first result set while INTERSECT returns the common rows of both the result sets.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

A is false but R is true.

Explanation
The MINUS operator returns the rows that are only in the first result set but not in the second, while the INTERSECT operator returns all rows that are in both result sets. Hence, the MINUS and INTERSECT operators are different.