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 is the syntax and use of the coalesce function?

1 Answers  

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

Difference between a query and strored procedure?

4 Answers   Microsoft,

what are enums used for in mysql? : Sql dba

1 Answers  

What is RAC in oracle?

7 Answers   MCN Solutions,

What are the operators used in select statements?

1 Answers  

What are the blocks in stored procedure?

6 Answers   Microsoft,

How does sql profiler work?

1 Answers  

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

When you have to use a default "rollback to" savepoint of plvlog?

1 Answers  

Why do we need unique key in a table?

1 Answers  

How do we accept inputs from user during runtime?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories