City Guilds Model Questions Vol1 2024 Information Technology Question 20
Practice objective / multiple choice question 20 from the 2024 City Guilds Model Questions Vol1 Information Technology examination.
A database contains three tables: Employees (E) with 2,000 rows, Departments (D) with 50 rows, and Projects (P) with 300 rows. Each employee belongs to exactly one department, and only 10 % of employees are assigned to a project. The join conditions are E.dept_id = D.id and E.proj_id = P.id. Considering two possible join orders—(E ⋈ D) then ⋈ P, and (E ⋈ P) then ⋈ D—estimate the size of the intermediate results for each order and state which order minimizes the size of the largest intermediate result.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2024 Information Technology Question 20. It is one of the objective questions from the 2024 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.