Which set operation represents rows that are in R1 but not in R2?

2025

Which set operation represents rows that are in R1 but not in R2?

  1. A.

    R1 ∪ R2

  2. B.

    R1 ∩ R2

  3. C.

    R2 - R1

  4. D.

    R1 - R2

  5. E.

    None of the above

Attempted by 66 students.

Show answer & explanation

Correct answer: D

Correct answer: R1 - R2.

The difference operation keeps tuples that are present in the first relation and removes tuples that also appear in the second relation. Therefore, rows in R1 but not in R2 are represented by R1 - R2.

Explore the full course: Niacl Ao It Specialist