InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
In which join all the rows from the left table appear in the output irrespective of the content of the other table?(a) RIGHT JOIN(b) LEFT JOIN(c) INNER JOIN(d) OUTER JOIN |
|
Answer» Correct choice is (b) LEFT JOIN Best explanation: In a ‘LEFT JOIN’, the output is produced for every row of the left table, even if it does not exist in the right table. This is the reason it is called a ‘LEFT JOIN’. ‘LEFT JOIN’ is a kind of OUTER JOIN. |
|