A and C.
There's no performance benefit or hit by using ANSI joins rather than traditional joins, but by using ANSI joins, your queries are more portable between DBMS platforms, and they're a bit easier to read.
http://www.dba-oracle.com/oracle_news/2004_2_19_rittman.htm
So now we have to choose between A and C or A and E
After reading through following explanation it seems to me that there are some specific cases where traditional joins perform better
Source (taken from ama's post up there): https://stackoverflow.com/questions/58476906/1z0-071-oracle-exam-question-which-answers-is-correct
But generally speaking there shouldn't be any big differences in performance between traditional and ansi join syntax - I am pretty sure that there are also some specific cases where ansi joins perform better than traditional joins.
So in that case I would go with A and C and just hope for the best!
193 / 5.000
A- Alias does not interfere with query performance.
B- Yes, between has better performance
C- True
D It is not true that <= and >= have better performance than between
E- False
Answer: B and C
A - true; there can be a performance benefit when using table aliases
B - false; there is no performance benefit difference when using keyword BETWEEN or operators <= =>
C - true; there is no difference in performance when using SQL 1999 ANSI join syntax or Oracle syntax
D - false; see answer B
E - false; see answer C
Sources
A - https://orawiss.wordpress.com/table-alias-speed-up-database-access/
According to the Oracle Sql fundamentals written by Nancy Greenberg and reviewed by a few technical contributors in the page 151, the Table aliases speed up database access and the Table aliases can help to keep SQL code smaller by conserving memory.
can you Elaborate more ? is this a guess or you have evidence?
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
khalilshahin01
Highly Voted 4 years, 4 months agoavanand
Highly Voted 4 years, 4 months agoEkos
4 years agoadoptc94
4 years, 4 months agoFan
3 years, 9 months agoyukclam9
3 years, 8 months agoRafafm
Most Recent 2 months agonautil2
1 year, 2 months agoauwia
1 year, 6 months agoRaNik69
1 year, 7 months agoryuah
2 years, 11 months agoChansi
4 years, 4 months agoama
4 years, 4 months agoyou1234
4 years, 5 months agoama
4 years, 5 months agodotruonghan
4 years, 5 months agoyou1234
4 years, 6 months agoama
4 years, 6 months ago