Which join combines all rows from both tables?

Options
- Inner Join
- Left Outer Join
- Right Outer Join
- Cross Join


CORRECT ANSWER : Cross Join

Discussion Board
CROSS JOIN

CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table if no WHERE clause is used along with CROSS JOIN. This kind of result is called as Cartesian Product.

Prajakta Pandit 03-9-2017 12:55 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement