Multiple choice technology databases

____________ is used to join a table to itself.

  1. Selfjoin

  2. Outerjoin

  3. innerjoin

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

A self-join joins a table to itself, typically to compare rows within the same table. It requires table aliases to distinguish the two instances of the table. Outer join returns all rows from one table plus matching rows from another. Inner join returns only matching rows. Equi-join is a join using = operator.

Keep practicing — related questions