1)CROSS JOIN

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 / tulsi

2 Answers
7327 Views
I also Faced
E-Mail Answers

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 are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

What is int identity in sql?

1140

How many clustered indexes can you have?

973

What are the commands used in sql?

1079

what are the t string functions available in tsql? : Transact sql

1007

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1232

Is nosql relational?

943

What are the two types of exceptions in pl/sql?

1052

What are analytical functions in sql?

1028

What is pls integer?

1042

Define implicit and explicit cursors.

1144

explain advantages of myisam over innodb? : Sql dba

1069

What is Histogram?

1557

Why query optimization is needed?

922

What is user in sql?

1019