Question

Lena wants to alter a table in her database using SQL commands.Which category of commands should she use?

Answer 1

Answer:

ALTER TABLE – ADD

ADD is used to add columns into the existing table. Sometimes we may require to add additional information, in that case we do not require to create the whole database again, ADD comes to our rescue.

ALTER TABLE – DROP

DROP COLUMN is used to drop column in a table. Deleting the unwanted columns from the table.

ALTER TABLE-MODIFY

It is used to modify the existing columns in a table. Multiple columns can also be modified at once.

Happy to help :)

Tell Lena too!! lol XD

Answer 2

Answer:

Ddl

Explanation: