Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 32 of 91

JOINS and SET Operations — Question 8

Back to all questions
8
Question

Question 8

In which type of join, no duplicate columns are there ?

  1. Equi-join
  2. Natural
  3. Left Join
  4. Right Join
Answer

Natural

Reason — In a natural join, no duplicate columns appear in the output table. This is because a natural join is a type of join in which only one of the identical columns (coming from the joined tables) is included in the output.