Oracle Database Administration I — Question 158

Which two statements are true regarding non-equijoins? (Choose two.)

Answer options

• A. Table aliases must be used.
• B. The Oracle join syntax can be used.
• C. The SQL1999 compliant ANSI join syntax must be used.
• D. The USING clause can be used.
• E. The ON clause can be used.

Correct answer: B, E

Explanation

Option B is correct because non-equijoins can indeed utilize the Oracle join syntax. Option E is also correct as the ON clause is often used in non-equijoins to specify the join condition. Options A, C, and D are incorrect; table aliases are not mandatory, SQL1999 syntax is not required, and the USING clause is not specifically tied to non-equijoins.