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

JOINS and SET Operations — Question 10

Back to all questions
10
Question

Question 10

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

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

Equi-join

Reason — The ON subclause in a SELECT statement produces an equi-join, where columns from the joined tables are compared for equality using the specified conditions in the ON clause.