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

JOINS and SET Operations — Question 9

Back to all questions
9
Question

Question 9

With SELECT statement used for joins, the USING subclause produces ............... join.

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

Natural

Reason — The USING subclause in a SELECT statement produces a natural join, where columns with the same name in the joined tables are automatically used as join conditions, resulting in a natural join operation.