Oracle Database SQL — Question 207

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

Answer options

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

Correct answer: D, E

Explanation

The correct answers are D and E because non-equijoins can utilize the Oracle join syntax and the ON clause to specify join conditions. Options A and B are incorrect as they do not specifically apply to non-equijoins; aliases and ANSI syntax are not mandatory for such joins. Option C is also incorrect since the USING clause is not typically associated with non-equijoins.