Neco 2019 Data Processing Question 15

Practice objective / multiple choice question 15 from the 2019 Neco Data Processing examination.

Neco 2019 Data Processing Objective / Multiple Choice Medium Difficulty
Question 15 NECO • 2019 • DATA_PROCESSING • objective

The table EMP contains the columns EmpID, Dept and Salary with the following data:\n\nEmpID | Dept | Salary\n1 | A | 5000\n2 | A | 7000\n3 | B | 6000\n4 | B | 8000\n5 | C | 4000\n6 | C | 5000\n7 | D | 9000\n\nUsing SQL, list the department(s) whose average salary is greater than the overall average salary of the company.

Answer Options

A. B and C
B. A and D
Correct Answer C. B and D
D. A and C
Correct Answer
C
Correct Option:
B and D

About This Question

This is Neco 2019 Data Processing Question 15. It is one of the objective questions from the 2019 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2019 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support