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

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 the difference between execution of triggers and stored procedures?

748


What is query execution plan in sql?

773


Which is better varchar or nvarchar?

732


What is the difference between pl and sql?

734


What is data type in sql?

727






What is the difference between stored procedure and view?

736


explain the options of myisamchk to improve the performance of a table. : Sql dba

721


What is difference between stored function and application function?

760


How does cross join work?

655


Can we insert in view in sql?

776


What is the need of merge statement?

762


What is structural independence and why is it important?

755


how to load data files into tables with 'mysqlimport'? : Sql dba

744


Why indexing is needed?

726


What is the use of function in sql?

728