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

Grouping Records, Joins in SQL — Question 7

Back to all questions
7
Question

Question 7

Assertion. In order to carry out the join operation, there should be a governing condition.

Reason. A join condition may be based on equality, less than, greater than or non-equality.

Answer

(d)

Assertion is false but Reason is true.

Explanation
In order to carry out the join operation, there should be a governing condition is false. This is because a Cartesian join is an example of a join operation that does not require a specific condition; it combines all rows from one table with all rows from another table without any matching condition. A join condition may be based on equality, less than, greater than, or non-equality depending on the requirements of the query.