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
Answers were Sorted based on User's Feedback
Answer / kumar srinivasalu
Cross join it is otherwise called cartesian join
| Is This Answer Correct ? | 14 Yes | 0 No |
what is the difference between cluster and non cluster index? : Sql dba
What are sql ddl commands?
Explain the types of joins in sql?
what are the advantages of using stored procedures? : Sql dba
Which command is used to delete a trigger?
What are the different types of joins in sql?
What packages are available to pl/sql developers?
What is microsoft t sql?
How to maintain the history of code changes of pl/sql?
Is sql between inclusive?
how to use regular expression in pattern match conditions? : Sql dba
how to use case expression? : Sql dba
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)