1)CROSS 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 / tulsi

2 Answers
7213 Views
I also Faced
E-Mail Answers

Answer Posted / tulsi

1)CROSS JOIN

Is This Answer Correct ?

12 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger in pl sql?

954

What is cross join sql?

865

Can a commit statement be executed as part of a trigger?

995

Inline the values in PL/SQL, what does it mean.?

1156

Can one improve the performance of sql*loader? : aql loader

980

What is query execution plan in sql?

1127

What are the types of sql commands?

1018

Write the command to remove all players named sachin from the players table.

1120

What is trigger price?

924

What is sql architecture?

980

Is trigger a stored procedure?

884

How to create a menu in sqlplus or pl/sql?

1062

What is a delimiter in sas?

977

What does over partition by mean in sql?

919

Which is better join or inner query?

959