Vidyalelo
PHP · Q35

Databases Handling

Programming · PHP · question 35

Q35

What does the DESC keyword do in the following query? SELECT * FROM MY_TABLE WHERE ID > 0 ORDER BY ID, NAME DESC"

A.
It causes the dataset returned by the query to be sorted in descending order
B.
It causes rows with the same ID to be sorted by NAME in ascending order
C.
It causes rows with the same ID to be sorted by NAME in descending order
Answer
D.
It causes rows to be sorted by NAME first and then by ID
E.
It causes the result set to include a description of the NAME field

Answer: Option C

Solution

Answer: Option C
No explanation is given for this question Let's Discuss on Board