ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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

Answer & Solution
Correct Answer: Option A
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".
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.