Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 182

Examine the description of the EMPLOYEES table:

Which two queries return the highest salary in the table?

SELECT MAX(salary)

FROM employees -

GROUP By department_id -

HAVING MAX(salary) = MAX(MAX(salary));

SELECT MAX(salary)

FROM employees -

GROUP By department_id;

SELECT department_id, MAX(salary)

FROM employees -

GROUP By department_id;

SELECT MAX(salary)

FROM employees;

SELECT MAX(MAX(salary))

FROM employees -

GROUP By department_id;

Correct Answer: D, E

To find the highest salary in the EMPLOYEES table, you should use queries that directly target the maximum salary. Option D achieves this by simply selecting the maximum salary from the entire table, which is straightforward and correct. Option E, despite seeming unusual with its use of MAX(MAX(salary)), is also correct because it effectively groups the data first and then applies the MAX function again to ensure the highest value is retrieved from those groups. This method ensures that the absolute highest salary across all departments is returned.

Discussion

jfc1Options: DE

DE is correct

tjswegOptions: CD

how is it not C & D? E doesn't make sense?

zouve

DE tested

DarnunOptions: DE

DE are correct answers

Misi_OracleOptions: DE

D and E is correct. A produce an error B and C select highest salary based on department D and E select highest salary in the table

yaya32Options: DE

I think DE is correct.

deepzsivaOptions: DE

DE is correct answer. Tested

Salmanbutt786Options: DE

I have tested DE is correct.

lucemqyOptions: DE

DE is the correct answer

CyberPOptions: BC

E is wrong, you cant have Max(Max) an aggregate of aggregate Maybe B,C,E are correct but A,E are wrong

CyberP

I mean B,C,D are correct