City Guilds Model Questions Vol1 2024 Information Technology Question 47
Practice objective / multiple choice question 47 from the 2024 City Guilds Model Questions Vol1 Information Technology examination.
A company's database contains two tables.\n\nEmployees(EmpID, DeptID, Salary)\nDepartments(DeptID, ManagerID, Budget)\n\nConstraints: each department has exactly three employees; each manager is also an employee; each employee works in exactly one department. The company has four departments, identified by distinct DeptID values, and the possible Budget values are 200 000, 300 000, 400 000 and 500 000 (one per department). Salary values are distinct within each department and can be any of 30 000, 35 000, …, 70 000 (increments of 5 000). Assuming each integer field occupies 4 bytes and each row has an overhead of 8 bytes, determine the total storage in bytes required for the natural join Employees ⋈ Departments on DeptID.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2024 Information Technology Question 47. It is one of the objective questions from the 2024 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.