Vidyalelo
MySQL · Q1048

MySQL

Programming · MySQL · question 1048

Q1048

"MODIFY" is used with which "Query clause"?

A.
ALTER
Answer
B.
FROM
C.
WHERE
D.
ORDER BY

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about how we change the structure of our tables in MySQL.
Imagine your table is like a spreadsheet with columns and rows.
"MODIFY" is a command that lets us change the existing columns in our table.

Out of the given options, "ALTER" is the query clause that works with "MODIFY."

So the answer is Option A: ALTER.

Think of it like this:

ALTER TABLE (This tells MySQL we want to change a table)
MODIFY (This tells MySQL we want to change a column within that table)

For example, if you want to change the data type of a column from 'INT' to 'VARCHAR', you would use the "ALTER" clause with "MODIFY".