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

JOINS and SET Operations — Question 7

Back to all questions
7
Question

Question 7

In which type of join, duplicate columns are there ?

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

Equi-join

Reason — In an equi-join, all columns from the joining tables appear in the output, even if they are identical. This can result in duplicate columns in the output table.