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 are different types of triggers?
What is the difference between sql and isql*plus?
What is sqlexception in java?
What is the difference between SQL table and the PLSQL table?
What is mutating trigger?How to avoid it??
How to pipe multiline string to isql?
Why do we use sql constraints?
what is constraining table?
what is global variable in pl/sql
What are pl/sql cursor exceptions?
use of IN/ANY/ALL
Can we interchange parameters in procedure while calling
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)