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
7210 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

How can I change database name in sql?

1000

What are types of joins?

905

how to fetch common records from two tables? : Sql dba

1105

What type of database is sql?

977

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1039

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

928

What is asqueryable?

902

What is pivot in sql?

870

How do I run a sql query?

967

How can a pl sql block be executed?

888

What is where clause in sql?

981

Is sql free?

885

Can we create foreign key without primary key?

930

How is a process of pl/sql compiled?

1081

Can we insert data into materialized view?

896