ISRO | ISRO CS 2020 | Question 66
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
Last Updated :
09 Sep, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...