FUNDAMENTALS OF COMPUTER

APPLICATION SYSTEM SOFTWARE

DESKTOP PUBLISHING WORD PROCESSING SOFTWARE

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To organize the student’s names alphabetically in a database, you would need to sort in:
A
Correct order
B
Ascending order
C
True order
D
Descending order
Explanation: 

Detailed explanation-1: -The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

Detailed explanation-2: -By default, ORDER BY without any additional specifier sorts in ascending order (equivalent to using the ASC keyword explicitly).

Detailed explanation-3: -Still it’s easy to remember: ascending = increasing for numbers and alphabetical order for letters. Descending = the opposite.

There is 1 question to complete.