Code with Shreya
GATE
Job prep
Subjects
Blog
Videos
Quizzes
PYQ
Compiler
Tools
Back to all quizzes
Intermediate · SQL / Normalization / Transactions
DBMS Essentials
10 questions
Question 1 of 10
Score 0
Which SQL join returns all rows from the left table, with NULLs where there is no match on the right?
INNER JOIN
LEFT JOIN
RIGHT JOIN
CROSS JOIN
Next question