Oracle
1Z0-071 · Question #129
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.)
The correct answer is B. SELECT minsal, maxsal D. SELECT MIN(Salary), MAX(salary). See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- ASELECT MIN(Salary) minsal, MAX(salary) maxsal
- BSELECT minsal, maxsal
- CSELECT minsal, maxsal
- DSELECT MIN(Salary), MAX(salary)
How the community answered
(24 responses)- A8% (2)
- B75% (18)
- C17% (4)
Community Discussion
No community discussion yet for this question.