Oracle
1Z0-071 · Question #136
View the exhibit and examine the description of the EMPLOYEES table. (Choose two.) You executed this SQL statement: SELECT first_name, department_id, salary FROM employees ORDER BY department_id…
The correct answer is A. The values in the SALARY column would be returned in descending order for all employees B. The values in the FIRST_NAME column would be returned in ascending order for all employees. See the full explanation below for the reasoning.
Question
View the exhibit and examine the description of the EMPLOYEES table. (Choose two.) You executed this 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 result? (Choose two.)
Options
- AThe values in the SALARY column would be returned in descending order for all employees
- BThe values in the FIRST_NAME column would be returned in ascending order for all employees
- CThe values in the SALARY column would be returned in descending order for all employees
- DThe values in all columns would be returned in descending order.
- EThe values in the FIRST_NAME column would be returned in descending order for all employees
How the community answered
(56 responses)- A82% (46)
- C5% (3)
- D4% (2)
- E9% (5)
Community Discussion
No community discussion yet for this question.