ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 190 discussion

Actual exam question from Oracle's 1z0-071
Question #: 190
Topic #: 1
[All 1z0-071 Questions]

Examine the description of the EMPLOYEES table:



Which two queries return the highest salary in the table?

  • A. SELECT MAX(salary)

    FROM employees -

    GROUP By department_id -
    HAVING MAX(salary) = MAX(MAX(salary));
  • B. SELECT MAX(salary)

    FROM employees -
    GROUP By department_id;
  • C. SELECT department_id, MAX(salary)

    FROM employees -
    GROUP By department_id;
  • D. SELECT MAX(salary)
    FROM employees;
  • E. SELECT MAX(MAX(salary))

    FROM employees -
    GROUP By department_id;
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
by jfc1 at Feb. 16, 2023, 4:38 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jfc1
Highly Voted 1 year, 4 months ago
Selected Answer: DE
DE is correct
upvoted 6 times
...
Misi_Oracle
Most Recent 2 months ago
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
upvoted 1 times
...
yaya32
5 months, 3 weeks ago
Selected Answer: DE
I think DE is correct.
upvoted 1 times
...
deepzsiva
5 months, 3 weeks ago
DE is correct answer. Tested
upvoted 1 times
...
Salmanbutt786
6 months ago
I have tested DE is correct.
upvoted 1 times
...
lucemqy
8 months ago
Selected Answer: DE
DE is the correct answer
upvoted 1 times
...
tjsweg
10 months, 2 weeks ago
how is it not C & D? E doesn't make sense?
upvoted 2 times
...
zouve
1 year ago
DE tested
upvoted 2 times
...
CyberP
1 year, 1 month ago
Selected Answer: BC
E is wrong, you cant have Max(Max) an aggregate of aggregate Maybe B,C,E are correct but A,E are wrong
upvoted 1 times
CyberP
1 year, 1 month ago
I mean B,C,D are correct
upvoted 1 times
...
...
Darnun
1 year, 3 months ago
Selected Answer: DE
DE are correct answers
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago