Oracle Database SQL — Question 216

Which two join conditions in a FROM clause are non-equijoins? (Choose two.)

Answer options

• A. table1 JOIN table2 USING (column1, column2)
• B. table1 JOIN table2 ON (table1.column BETWEEN table2.column1 AND table2.column2)
• C. table1 NATURAL JOIN table2
• D. table1 JOIN table2 ON (table1.column >= table2.column)
• E. table1 JOIN table2 ON (table1.column = table2.column) WHERE table2.column LIKE ‘A%’

Correct answer: B, D

Explanation

The correct answers, B and D, represent non-equijoins because they use conditions that are not based on equality. Option B uses a BETWEEN condition, and option D uses a greater than or equal to condition. The other options either use equality or are structured in ways that do not represent non-equijoins.