Home » MCQs » SQL MCQs » SQL Basics (Set 2) MCQs

What does the ALTER TABLE Statement do?

9. What does the ALTER TABLE Statement do?

1. By deleting the stored data, this SQL statement deletes the database.
2. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
3. A new table in SQL is created using this SQL statement.
4. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.

Answer: B) Columns in the SQL database can be created, deleted, or modified with this SQL statement

Explanation:

Columns in the SQL database can be created, deleted, or modified with ALTER TABLE SQL statement.