Vidyalelo
MySQL · Q101

MySQL

Programming · MySQL · question 101

Q101

Which keyword is used for sorting the data in ascending order in Mysql?

A.
DESC
B.
ASC
Answer
C.
ALTER
D.
MODIFY

Answer: Option B

Solution

Answer: Option B
Solution:
This question is about how to arrange data in a table from smallest to largest in MySQL.

Think of it like sorting your toys by size – you want the smallest ones first, then the bigger ones.

Here's how the options relate to the question:

Option A: DESC - This keyword is for *descending* order, meaning it sorts from largest to smallest.
Option B: ASC - This is the correct answer! It stands for *ascending*, which means sorting from smallest to largest.
Option C: ALTER - This is used to change the structure of a table, not for sorting data.
Option D: MODIFY - Similar to ALTER, this is used for modifying the table's structure, not sorting data.

So, if you want to see your data in order from smallest to largest, you'd use the ASC keyword.