Which three statements are true about the Oracle join and ANSI join syntax?
A. The Oracle join syntax supports natural joins.
B. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
C. The Oracle join syntax supports creation of a Cartesian product of two tables.
D. The SQL:1999 compliant ANSI join syntax supports natural joins.
E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
F. The Oracle join syntax only supports right outer joins.
G. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
CDG
CDG
CDG
Why the Oracle join syntax dont supports natural joins ?
https://oracle-base.com/articles/9i/ansi-iso-sql-support
https://docs.oracle.com/cd/B10501_01/server.920/a96540/queries7.htm#2054014
A only not true for early version of 9i? ACDG all appear to be correct!?
ACE
CDG