Multiple choice technology databases

Which join requires denormalisation of the table

  1. Self Join

  2. Cartesian Join

  3. Cross Join

  4. Hash Join
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A self-join requires treating a single table as if it were multiple tables using different aliases (e.g., employees e1 JOIN employees e2), which can be conceptualized as denormalization for the join operation. Unlike other join types that combine distinct tables, a self-join operates on one table by creating virtual copies through aliasing.

Keep practicing — related questions