Examveda
Examveda

............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

A. EQUIJOIN

B. NON-EQUIJOIN

C. OUTER JOIN

D. NATURAL JOIN

Answer: Option B

Solution(By Examveda Team)

The type of join that involves joining two or more tables based on a specified column value not equaling a specified column value in another table is known as a NON-EQUIJOIN. In a non-equijoin, the condition for joining is based on inequality or non-equality of values between the columns in different tables.

Option A: EQUIJOIN - This type of join matches tables based on the equality of column values and is not relevant to non-equijoin.
Option C: OUTER JOIN - An outer join includes unmatched rows from one or both tables but doesn't specifically indicate non-equality.
Option D: NATURAL JOIN - A natural join matches columns with the same name in the joined tables, but it is not related to non-equality.

So, the correct answer is Option B: NON-EQUIJOIN, as it accurately describes a join based on non-equality of column values in different tables.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Related Questions on Sql Miscellaneous