Oracle
1Z0-071 · Question #281
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
The correct answer is 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. G. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables. See the full explanation below for the reasoning.
Question
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
Options
- AThe Oracle join syntax supports natural joins.
- BThe Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
- CThe Oracle join syntax supports creation of a Cartesian product of two tables.
- DThe SQL:1999 compliant ANSI join syntax supports natural joins.
- EThe Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
- FThe Oracle join syntax only supports right outer joins.
- GThe SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
How the community answered
(49 responses)- A6% (3)
- B2% (1)
- C76% (37)
- E14% (7)
- F2% (1)
Community Discussion
No community discussion yet for this question.