Which of the following query transformations, obtained by replacing the…

GATE · Computer Science · 1998

Which of the following query transformations, obtained by replacing the left-hand side expression by the right-hand side expression, is incorrect?

R₁ and R₂ are relations. C₁ and C₂ are selection conditions, and A₁ is an attribute set of R₁.

a. σ_{C₁}(σ_{C₂}(R₁)) → σ_{C₂}(σ_{C₁}(R₁))

b. σ_{C₁}(π_{A₁}(R₁)) → π_{A₁}(σ_{C₁}(R₁))

c. σ_{C₁}(R₁ ∪ R₂) → σ_{C₁}(R₁) ∪ σ_{C₁}(R₂)

d. π_{A₁}(σ_{C₁}(R₁)) → σ_{C₁}(π_{A₁}(R₁))

  1. A.

    a

  2. B.

    b

  3. C.

    c

  4. D.

    d

Attempted by 38 students.

Show answer

Correct answer: D

The worked solution is available to enrolled students.

Explore the full course: Iocl Engineers Officers Grade A Paper 2

Loading lesson…