Which one of the following join types will always create a
Cartesian Product?
1. CROSS JOIN
2. LEFT OUTER JOIN
3. RIGHT OUTER JOIN
4. FULL OUTER JOIN
5. INNER JOIN
- 2 Answers
- 6498 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar srinivasalu
Cross join it is otherwise called cartesian join
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What are the types of sql commands?
What is clause?
What do you mean by stored procedures?
Is sql considered coding?
What is rollback?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is cursor and its types?
Which is better join or inner query?
What are the various levels of constraints?
is mysql query is case sensitive? : Sql dba
What are the possible values that can be stored in a boolean data field?
What is pivot in sql?
What is pls_integer in pl sql?
What is the need of a partition key?
How do you run a query?
