Oracle Database Administration I — Question 133

Which two statements are true about the Oracle join and ANSI join syntax? (Choose two.)

Answer options

• A. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
• B. The Oracle join syntax lacks the ability to do outer joins.
• C. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
• D. The Oracle join syntax supports creation of a Cartesian product of two tables.
• E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

Correct answer: C, D

Explanation

Option C is correct because the SQL:1999 compliant ANSI join syntax does indeed allow for the creation of a Cartesian product. Option D is also correct as the Oracle join syntax supports creating a Cartesian product. Options A, B, and E are incorrect because they misrepresent the capabilities of the Oracle join syntax and its performance relative to the ANSI syntax.