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 does a pl/sql package consist of?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is triggering circuit?
When is a declare statement required?
what is the boundary line in varrays?
How run sql*plus commands that are stored in a local file?
What is pivot query?
How do you pronounce sql?
What is a unique key?
What is difference between Procedures and Functions ?
When are we going to use truncate and delete?
Can we have exception part in trigger ?
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)