Neco 2019 Data Processing Question 1
Practice objective / multiple choice question 1 from the 2019 Neco Data Processing examination.
Table Employees has 120 records, each with fields EmpID, DeptID, Salary. Table Departments has 8 records with fields DeptID, ManagerID, Budget. Each department employs exactly 15 employees. Only departments whose Budget exceeds \(\text{\₦}500{,}000\) are to be considered. From the Employees table, select those with Salary greater than \(\text{\₦}70{,}000\) and perform a natural join with the qualifying Departments. How many rows are returned by the query?
Answer Options
About This Question
This is Neco 2019 Data Processing Question 1. It is one of the objective questions from the 2019 Neco Data Processing 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.