Multiple choice technology databases

Which of the following is FALSE about a ALTER TABLE command of SQL?

  1. ALTER TABLE command is used to create a table

  2. ALTER TABLE command is used to change the column elements in a table

  3. ALTER TABLE command is used to delete a table

  4. Both A. and C.

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The ALTER TABLE command is used to modify the structure of an existing table (like changing columns), not to create (CREATE TABLE) or delete (DROP TABLE) a table. Therefore, both A and C are false statements about ALTER TABLE, making this option correct.