> > >

Oracle 12c Admin MCQs

Carefully study the data in the EMPLOYEES table that is given in the image and answer the following question.
Which of the following Subqueries will work?

SELECT ' FROM employees where salary > (SELECT MlN(salary) FROM employees GROUP BY department_id);

SELECT “ FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

III SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

II SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

Answer

Correct Answer:

SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle 12c Admin Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it