Oracle
1Z0-047 · Question #182
View the Exhibit and examine the description of the EMPLOYEES table. You executed the following SQL statement: SELECT first_name, department_id, salary FROM employees ORDER BY department_id…
The correct answer is C. The values in the FIRST_NAME column would be sorted in ascending order for all the employees having E. The values in the SALARY column would be sorted in descending order for all the employees having the. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the description of the EMPLOYEES table. You executed the following SQL statement:
SELECT first_name, department_id, salary FROM employees ORDER BY department_id, first_name, salary desc; Which two statements are true regarding the output of the above query? (Choose two.)
Exhibit
Options
- AThe values in all the columns would be sorted in the descending order.
- BThe values in the SALARY column would be sorted in descending order for all the employees having
- CThe values in the FIRST_NAME column would be sorted in ascending order for all the employees having
- DThe values in the FIRST_NAME column would be sorted in the descending order for all the employees
- EThe values in the SALARY column would be sorted in descending order for all the employees having the
How the community answered
(27 responses)- A4% (1)
- B4% (1)
- C81% (22)
- D11% (3)
Community Discussion
No community discussion yet for this question.