View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)
You executed this SQL statement:
Which two statements are true regarding the result?
A. The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
B. The values in the FIRST_NAME column would be returned in ascending order for all employees having the same value in the DEPARTMENT_ID column.
C. The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
D. The values in the all columns would be returned in descending order.
E. The values in the FIRST J4AME column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
|
Download Printable PDF. VALID exam to help you PASS. |
 |