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
Answer Posted / kumar srinivasalu
Cross join it is otherwise called cartesian join
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What are the syntax and use of the coalesce function?
Is it possible to create startup or shutdown trigger for on-schema?
What is on delete set null?
what is schema? : Sql dba
how to get a list of all tables in a database? : Sql dba
what are sequences
What is pessimistic concurrency control? : Transact sql
What is database white box testing and black box testing?
List the various privileges that a user can grant to another user?
Who is the owner of mysql database?
what is the difference between primary key and unique key? : Sql dba
Why left join is used in sql?
What is replication id?
How to add new employee details in an employee_details table with the following details
What are types of exception?