🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: SQL Joins: all 10 questions

Quiz: SQL Joins · Question 6 of 10

How many rows does departments LEFT JOIN employees ON e.deptid = d.deptid return for the company tables?

How many rows does departments LEFT JOIN employees ON e.dept_id = d.dept_id return for the company tables?

  1. A.4
  2. B.6
  3. C.7
  4. D.28
Answer & explanation

Correct answer: 7

6 matched employees plus one row for Marketing with NULL employee columns. Arjun is not included because departments is the left table.

Can you get the rest right without peeking?

Take the timed Quiz: SQL Joins quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →