Multiple choice

When one of the two identical columns is removed in join query, this is called________ query.

  1. Equi Join

  2. Natural Join

  3. Inner Join

  4. Unconditional Join
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A Natural Join automatically joins tables based on columns with the same name and removes the duplicate columns from the result set.

Keep practicing — related questions