- Home
- Class - 12 CBSE Computer Science — Assertion Reason Type Questions
Assertion. The join, in which columns are
Class - 12 CBSE Computer Science — Assertion Reason Type Questions
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.