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 |
how to saw triggers output in pl/sql database?
can we call a procedure from a function?
What is the difference between Union and Union all. Which is faster.
what is user defined functions? : Sql dba
Compare sql & pl/sql
How do I turn a list into a table?
how to retrieve the top 2 salaried persons from a database?
Is sqlite good enough for production?
What is the purpose of my sql?
What is the best free sql database?
How do you select unique values in sql?
What are the disadvantages of not performing database normalization?
Oracle (3259)
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)