Question

What does the ALTER TABLE clause do?

(a) The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

(b) The SQL ALTER TABLE clause is used to insert data into database table

(c) THE SQL ALTER TABLE deletes data from database table

(d) The SQL ALTER TABLE clause is used to delete a database table

This question was posed to me during an interview for a job.

My question comes from Basic SQL topic in chapter Laying the Foundation of SQL Server

Answer 1

Right choice is (a) The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

Easiest explanation: The ALTER TABLE statement is used to add, delete, or modify columns.