Q1048
"MODIFY" is used with which "Query clause"?
A.
ALTER
AnswerB.
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".