Oracle
1Z0-071 · Question #136
1Z0-071 Question #136: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.
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
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.