The SQL query SELECT columns FROM TableA RIGHT OUTER JOIN TableB ON…

2020

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

Answer: E. None of these — Query returns records of table B which are failed equality condition of join. Option (E) is correct.

1. A.

   All rows in Table B, which meets equality condition above and, none from Table A, which meets the condition

2. B.

   All rows in Table A, which meets equality condition above and none from Table B, which meets the condition

3. C.

   All rows in Table B, which meets equality condition

4. D.

   All rows in Table A, which meets equality condition

5. E.

   None of these

Attempted by 427 students.

A video solution is available for this question — log in and enroll to watch it.