Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

ISRO | ISRO CS 2020 | Question 66

  • Last Updated : 09 Sep, 2020

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 B, which meets equality condition above and, none from Table A, which meets the condition
(B) All rows in Table A, which meets equality condition above and none from Table B, which meets the condition
(C) All rows in Table B, which meets equality condition
(D) All rows in Table A, which meets equality condition
(E) None of these


Answer: (E)

Explanation: Query returns records of table B which are failed equality condition of join.

Option (E) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!