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

How many columns should be in an index?

0 Answers  

what are the different tables present in mysql? : Sql dba

0 Answers  

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

What is oracle sql called?

0 Answers  




What are advantages of Stored Procedures?

3 Answers   Satyam,

What are sql data types?

0 Answers  

How many sql statements are used? Define them.

0 Answers  

Can a view be mutating? If yes, then how?

0 Answers  

What is the use of procedures?

0 Answers  

Does pl/sql support create command?

0 Answers  

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories