UGC NET CSE | July 2018 | Part 2 | Question: 61

Question

In RDBMS, which type of Join returns all rows that satisfy the join condition?

• A. Inner Join
• B. Outer Join
• C. Semi Join
• D. Anti Join

Answer 1

• A. Inner Join will only return the matched rows
• B. Outer Join will return all the rows  (ANSWER)
• C.  and D. will return conditional rows not all everytime