City Guilds Model Questions Vol1 2019 Information Technology Question 38
Practice objective / multiple choice question 38 from the 2019 City Guilds Model Questions Vol1 Information Technology examination.
The relation EMP contains 10 000 tuples with attributes (EmpID, DeptID, Salary, Age). DeptID values are uniformly distributed among 20 departments. Salary values are uniformly distributed between ₦30 000 and ₦120 000. Age values are uniformly distributed between 20 and 60 years. Estimate the number of distinct DeptID values returned by the query: SELECT DISTINCT DeptID FROM EMP WHERE Salary > 80 000 AND Age < 35; Assume Salary and Age are independent. Give your answer as an integer.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2019 Information Technology Question 38. It is one of the objective questions from the 2019 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.