Multiple choice technology databases

Which of the following joins is possible in SQL

  1. EQUI-JOIN

  2. NON EQUI-JOIN

  3. Both A. and B.

  4. None of the Above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL supports both EQUI-JOIN (joining using equality operator) and NON-EQUI-JOIN (joining using operators other than =, such as <, >, BETWEEN, etc.). An EQUI-JOIN is a join condition using =, while NON-EQUI-JOIN uses any other comparison operator.

AI explanation

'Both A and B' is correct. SQL supports EQUI-JOINs, which match rows using an equality condition (e.g., a.id = b.id), and NON-EQUI-JOINs, which match rows using any other comparison operator (e.g., a.value BETWEEN b.low AND b.high, or using <, >, !=). Both are valid, standard join types supported by SQL — neither is exclusive of the other, so restricting the answer to just one type would be incomplete, and 'none of the above' is clearly wrong since both types demonstrably exist.

Keep practicing — related questions