Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 5 of 91

Grouping Records, Joins in SQL — Question 5

Back to all questions
5
Question

Question 5

Assertion. The join, in which columns are compared for equality, is called Equi-join.

Reason. The join queries only produce combined rows from tables having some common column, when compared for equality.

Answer

(c)

Assertion is true but Reason is false.

Explanation
The join, in which columns are compared for equality, is called Equi-join. Join queries in SQL can produce combined rows based on various conditions, not just equality comparisons. For example, join conditions can involve inequality comparisons (<, >, <=, >=), as well as other logical operators and functions.