Which of the following type of Join returns all rows from the left table even if no matches are found in the right table?

HSQLDB - MCQ(Quiz)

A) RIGHT JOIN

B) LEFT JOIN

C) INNER JOIN

D) All of the above

Correct Answer : LEFT JOIN

Explanation : LEFT JOIN returns all rows from the left table even if no matches are found in the right table.

Top Trending Technologies MCQ's

Machine Learning

Artificial Intelligence

Natural Language Processing

Top Trending Technologies Interview Questions