Examine the description of the EMPLOYEES table:
Which two queries return the highest salary in the table?
1z0-071 Exam QuestionsBrowse all questions from this exam
1z0-071 Exam - Question 182
Show AnswerHide Answer
Correct Answer: BCDE
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
10 commentsjfc1Options: DE
Feb 16, 2023DE is correct
DarnunOptions: DE
Apr 3, 2023DE are correct answers
zouve
Jul 2, 2023DE tested
tjswegOptions: CD
Sep 1, 2023how is it not C & D? E doesn't make sense?
CyberPOptions: BC
May 29, 2023E is wrong, you cant have Max(Max) an aggregate of aggregate Maybe B,C,E are correct but A,E are wrong
CyberP
May 29, 2023I mean B,C,D are correct
lucemqyOptions: DE
Nov 15, 2023DE is the correct answer
Salmanbutt786Options: DE
Jan 10, 2024I have tested DE is correct.
deepzsivaOptions: DE
Jan 18, 2024DE is correct answer. Tested
yaya32Options: DE
Jan 22, 2024I think DE is correct.
Misi_OracleOptions: DE
May 8, 2024D 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