Which statement is used to select columns and rows from the table?

Solution(By Examveda Team)

This question asks you about the command used in MySQL to retrieve data from a table. Think of it like asking for specific information from a file.

Here's what each option does:
Option A: SELECT - This is the correct answer! It's used to select specific columns (like names, ages, etc.) and rows (like individual entries) from your database table.
Option B: ALTER - This command is for changing the structure of a table. It's not used to retrieve data.
Option C: MODIFY - Similar to ALTER, this command is used to make changes to a table's structure, not to get data.
Option D: FROM - This is a part of the SELECT statement. It tells MySQL which table to get the data from.

In summary: The SELECT statement is the one that retrieves data from a table.
So the answer is Option A: SELECT