> > >

Oracle 12c Admin MCQs

Which of the following co—related SQL queries will return Employeeld, EmployeeName, Salary and Department of all those employees whose salary is more than the average salary of employees in that employee's department?

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee e WHERE Salary > (SELECT AVG(Salary) FROM Employee WHERE Salary = e.Department);

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee WHERE Salary >

(SELECT AVERAGE(Salary) FROM Employee WHERE Department = Department);

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee WHERE Salary >

(SELECT AVG(Salary) FROM Employee WHERE Department = Department);

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee 9 WHERE Salary >(SELECT AVG(Salary) FROM Employee WHERE Department = e.Department);

Answer

Correct Answer:

SELECT Employeeld, EmployeeName, Salary, Department FROM Employee 9 WHERE Salary >(SELECT AVG(Salary) FROM Employee WHERE Department = e.Department);

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