Which of the following functions are not performed by "ALTER" clause?
A. Change the name of the table
B. Change the name of the column
C. Drop a column
D. All of the mentioned
Answer: Option D
Solution (By Examveda Team)
The ALTER clause is a powerful tool in MySQL that lets you make changes to your existing tables. It's like editing a blueprint for your database!Think of it as a way to:
* Change table names: You can rename your tables with ALTER, like changing "Products" to "Items".
* Change column names: If you want to call a column "Quantity" instead of "Count", ALTER can help you.
* Remove columns: If you decide a column is no longer needed, ALTER can delete it from your table.
So, the answer to the question is: Option D: All of the mentioned
The ALTER clause can do all of these things!
It's a very versatile command for managing your database.

Join The Discussion