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

Solution (By Examveda Team)

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.