Cross join it is otherwise called cartesian join

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

Question Posted / kumar srinivasalu

2 Answers
7329 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

Please Help Members By Posting Answers For Below Questions

what is “go” in t-sql? : Transact sql

1104

How to prepare for oracle pl sql certification?

1065

How can you create an empty table from an existing table?

1079

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

explain the difference between bool, tinyint and bit. : Sql dba

1000

Differentiate pl/sql and sql?

1066

what happens if null values are involved in expressions? : Sql dba

1045

What is foreign key sql?

985

Can procedure in package be overloaded?

1085

What are different joins used in sql?

1056

Why left join is used in sql?

979

What is the purpose of a sql?

977

What is sql in java?

1087

what are the security recommendations while using mysql? : Sql dba

1118

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209