Vidyalelo
MySQL · Q175

MySQL

Programming · MySQL · question 175

Q175

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

Answer: Option D

Solution

Answer: Option D
Solution:
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.