Oracle Database SQL — Question 241

What is true about non-equijoin statement performance? (Choose two.)

Answer options

• A. The BETWEEN condition always performs less well than using the >= and <= conditions.
• B. The BETWEEN condition always performs better than using the >= and <= conditions.
• C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
• D. Table aliases can improve performance.
• E. The join syntax used makes no difference to performance.

Correct answer: D, E

Explanation

Option D is correct because using table aliases can make queries clearer and allow for better optimization by the database engine. Option E is also correct as the performance can be unaffected by the specific join syntax used, as long as the query is properly optimized. The other options either misrepresent the performance of BETWEEN conditions or compare join syntaxes incorrectly.