1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / suresh.chaluvadi

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 are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

what is inline command?

2 Answers  

Which tcp/ip port does sql server run?

0 Answers  

Can we interchange parameters in procedure while calling

1 Answers   TCS,

Can we write dml inside a function in sql server?

0 Answers  




What are the different sql languages?

0 Answers  

What is the difference between an inner join and an outer join?

0 Answers  

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

How you improve the performance of sql*loader? : aql loader

0 Answers  

What is package in pl sql?

0 Answers  

Why function is used in sql?

0 Answers  

Is ms sql is free?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories