City Guilds Model Questions Vol1 2018 Information Technology Question 17
Practice objective / multiple choice question 17 from the 2018 City Guilds Model Questions Vol1 Information Technology examination.
A company maintains two tables. - **Employees**(EmpID, DeptID, Salary) contains 8 rows. - **Departments**(DeptID, ManagerID, Budget) contains 5 rows. Each employee belongs to exactly one department. Exactly three departments have a Budget greater than \(100{,}000\) naira, and each department can have at most three employees. If we perform a natural join of **Employees** and **Departments** and then select only those rows where Salary \(> 50{,}000\) and Budget \(> 100{,}000\), what is the maximum possible number of rows in the resulting relation?
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2018 Information Technology Question 17. It is one of the objective questions from the 2018 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.