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

Answers were Sorted based on User's Feedback



Which one of the following join types will always create a Cartesian Product? 1. CROSS JO..

Answer / kumar srinivasalu

Cross join it is otherwise called cartesian join

Is This Answer Correct ?    14 Yes 0 No

Which one of the following join types will always create a Cartesian Product? 1. CROSS JO..

Answer / tulsi

1)CROSS JOIN

Is This Answer Correct ?    12 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is java sql package?

0 Answers  


Can a table have two primary keys?

44 Answers   HCL, MetaCube,


four procedures is are there should i write their in a package

2 Answers  


The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  


Where can I learn sql for free?

0 Answers  






Explain what is a database?

0 Answers  


What is meant by temporal data?

0 Answers  


HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  


Is sql database free?

0 Answers  


how to shutdown mysql server? : Sql dba

0 Answers  


Why are cursors used?

0 Answers  


Is a view faster than a stored procedure?

0 Answers  


Categories