ISRO2020-51

Question

The SQL query

SELECT columns
FROM TableA
RIGHT OUTER JOIN TableB
ON A.columnName = B.columnName
WHERE A.columnName IS NULL

returns the following:

• A. All rows in Table $\text{B}$, which meets equality condition above and, none from Table $\text{A}$ which meets the condition.
• B. All rows in Table $\text{A}$, which meets equality condition above and none from Table $\text{B}$, which meets the condition.
• C. All rows in Table $\text{B}$, which meets the equality condition
• D. All rows in Table $\text{A}$, which meets the equality condition

Comments

Not sure maybe option a).

---

None are correct.

Answer 1

 Table A

A	B
1	a
2	c

Table B:

C	D
1	b
3	d

Then, 

TableA RIGHT OUTER JOIN TableB ON A.columnName = B.columnName

A	B	C	D
1	a	1	b
NULL	NULL	3	d

Where A.columnName is NULL ------>>>>> return The row from table B which meet the equal condition but not the row from the Table A which meet the equal condition..