Oracle
1Z0-082 · Question #5
What is true about non-equijoin statement performance? (Choose two.)
The correct answer is A. Table aliases can improve performance E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
What is true about non-equijoin statement performance? (Choose two.)
Options
- ATable aliases can improve performance
- BThe BETWEEN condition always performs better than using the >= and <= conditions
- CThe join syntax used makes no difference to performance
- DThe BETWEEN condition always performs less well than using the >= and <= conditions
- EThe Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
How the community answered
(37 responses)- A84% (31)
- B3% (1)
- C8% (3)
- D5% (2)
Topics
#non-equijoin#join performance#BETWEEN condition#table aliases
Community Discussion
No community discussion yet for this question.