Which two statements are true regarding the output of the above query?

View the Exhibit and examine the description of the EMPLOYEES table. You executed the
following SQL statement: SELECTfirst_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.)

View the Exhibit and examine the description of the EMPLOYEES table. You executed the
following SQL statement: SELECTfirst_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.)

A.
The values in all the columns would be sorted in the descending order.

B.
The values in the SALARY column would be sorted in descending order for all the
employees having the same value in the DEPARTMENT_ID column.

C.
The values in the FIRST_NAME column would be sorted in ascending order for all the
employees having the same value in the DEPARTMENT_ID column.

D.
The values in the FIRST_NAME column would be sorted in the descending order for all
the employees having the same value in the DEPARTMENT_ID column.

E.
The values in the SALARY column would be sorted in descending order for all the
employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


KPD

KPD

If it is correct that two should be chosen, than answer B. would be correct, too.

amina

amina

i aggree with dames
rigth answers C & E
B must be : The values in the SALARY column would be sorted in descending order for all the
employees having the same value in column.

amina

amina

DEPARTMENT_ID and FIRST_NAME