Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 47

Total: 50

What is true about non-equijoin statement performance?

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

Go to Question:

Prev Question

Next Question