What is the output (number of records)? Table A with one column values (1,1,2,2,2,3,4,5) Table B with one column values (1,1,1,2,2,3) 1. A Union B 2. A Intersection B 3. (A Union B) minus (A intersection B) 4. A Minus B 5. A Inner Join B 6. A Left Join B 7. A Right Join B 8. A Full Join B 9. A Outer Join B

shaili

• Mar 2nd, 2017

A union B : 1,2,3,4,5
a intersection b:1,2,3
a union b minus a intersection b :4,5
a minus b : 4,5
a inner join B :1,1,1,1,1,1,2,2,2,2,2,2,3
a left join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5
a right join b :1,1,1,1,1,1,2,2,2,2,2,2,3
a full join b :1,1,1,1,1,1,2,2,2,2,2,2,3,4,5

ram

• May 30th, 2016

1. Union:(1,1,2,2,2,3,4,5)
2. Intersection:(1,1,2,2,3)
3. ::(2,4,5)
4. Aminus b:(2,4,5)

Answer Question  Select Best Answer