Question

Consider two tables: Employees(EmpID, Name, DeptI

  • D with 8 rows, and Departments(DeptID, DeptName) with 3 rows. Every employee has exactly one valid DeptID, and every department has at least one employee. How many rows will the following query return? SELECT E.Name, D.DeptName FROM Employees E INNER JOIN Departments D ON E.DeptID = D.DeptID;
A 3
B 5
C 11
D 24
E 8
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)