WHERE construct in SQL is equivalent to following relational algebra operator ?

2026

WHERE construct in SQL is equivalent to following relational algebra operator ?

  1. A.

    Π

  2. B.

    σ

  3. C.

    ×

  4. D.

Attempted by 232 students.

Show answer & explanation

Correct answer: B

The WHERE clause in SQL is used to filter rows based on specified conditions. In relational algebra, this filtering operation corresponds to the selection operator (σ), which selects tuples that satisfy a given predicate.

Explore the full course: Niacl Ao It Specialist