Oracle
1Z0-047 · Question #182
1Z0-047 Question #182: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #182. The question stem and answer options stay visible for context.
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
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.