Examveda

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

A. ALTER

B. FROM

C. WHERE

D. ORDER BY

Answer: Option A

Solution (By Examveda Team)

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".

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous