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 file based approach?
What is the location of pre_defined_functions.
Is it possible to read/write files to-and-from PL/SQL?
How many databases can sql express handle?
Write a sql query to get the third highest salary of an employee from employee_table?
What is schema in sql?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
Differentiate between syntax and runtime errors.
Why do you partition data?
Why do we create stored procedures & functions in pl/sql and how are they different?
How do you optimize a stored procedure query?
How do you modify a column in sql?
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)