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. | t causes the dataset returned by the query to be sorted in descending order |
| B. | t causes rows with the same ID to be sorted by NAME in ascending order |
| C. | t causes rows with the same ID to be sorted by NAME in descending order |
| D. | t causes rows to be sorted by NAME first and then by ID |
| E. | t causes the result set to include a description of the NAME field |
| Answer» D. t causes rows to be sorted by NAME first and then by ID | |