Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 17 of 50

Marks: +1, -0

Examine the structure of the EMPLOYEES table

You must display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would provide the correct output? (Choose two.)

SELECT MIN(Salary) minsal, MAX(salary) maxsal FROM employees WHERE hire_date < SYSDATE-365 GROUP BY MIN(salary), MAX(salary);
SELECT minsal, maxsal FROM (SELECT MIN(salary) minsal, MAX(salary) maxsa FROM employees WHERE hire_date < SYSDATE-365) GROUP BY maxsal, minsal;
SELECT minsal, maxsal FROM (SELECT MIN(salary) minsal, MAX(salary) maxsal FROM employees WHERE hire_date < SYSDATE-365 GROUP BY MIN(salary), MAX(salary));
SELECT MIN(Salary), MAX(salary) FROM (SELECT salary FROM employees WHERE hire_date < SYSDATE-365);

Go to Question:

Prev Question

Next Question