"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".
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion