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
- 6860 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 differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is where clause in sql?
Can you upgrade sql express to full sql?
what is a constraint? Tell me about its various levels. : Sql dba
what is a cursor? : Sql dba
How to write pl sql program in mysql command prompt?
what are the properties and different types of sub-queries? : Sql dba
explain primary keys and auto increment fields in mysql : sql dba
Is sql pronounced sequel or sql?
What are types of indexes in sql?
What is indexing in sql and its types?
how to rename an existing column in a table? : Sql dba
what is the difference between nested subquery and correlated subquery?
Differentiate between syntax and runtime errors.
how to select first 5 records from a table? : Sql dba
