City Guilds Model Questions Vol1 2023 Information Technology Question 34
Practice objective / multiple choice question 34 from the 2023 City Guilds Model Questions Vol1 Information Technology examination.
A company maintains a **Departments** table that contains 5 rows, each with a distinct \(ManagerID\). The average number of employees per department is 10. The **Employees** table stores one row per employee and includes the \(DeptID\) attribute. If an inner join of **Employees** and **Departments** is performed on \(DeptID\) and the result is then projected on the attributes \(DeptID\) and \(ManagerID\), how many rows are in the final projected result?
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2023 Information Technology Question 34. It is one of the objective questions from the 2023 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.