MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
What does the DESC keyword do in the following query?SELECT *FROM MY_TABLEWHERE ID > 0ORDER 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 |
| 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» D. It causes rows to be sorted by NAME first and then by ID | |