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

Outer Join return all rows that satisfy condition from both the participating relations.

Option (2) is correct.

Comments

It should be INNER join as OUTER join will return even those rows which not satisfy condition with NULL values

---

Inner Join should be right answer.

---

Yes, but technically even outer join is correct because it also return all the matching rows. Question does not specify "only".

Answer 2

Option 1

Comments

Yes u can challenge bro..It's 100% correct

---

<p>Yes u can challenge bro..It's 100% correct</p>

---

Also challenge ques no 100..It's option is 3

Answer 3

Inner Joins

An inner join (sometimes called a simple join) is a join of two or more tables that returns only those rows that satisfy the join condition.

Outer Joins

An outer join extends the result of a simple join. An outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition.

By the definition of outer join we can clearly see  that outer join return all row that satisfy the join condition  plus  other   row  that does not satisfy the join condition  this will occur in case of Left Outer Join and Right Outer join .which is part of Outer Join.

 

Hence more apropriate ans is 1(Inner Join).

Comments

also tell me is sufficient answer to challenge the ans key

Answer 4

Ans: (a) Inner Join