Multiple choice technology databases

To Insert new a column in a table Tbl_Test which of the following query is used

  1. Alter table Tbl_Test Insert column New_Column varchar 20

  2. Alter table Tbl_Test Alter column New_Column varchar 20

  3. Alter table Tbl_Test add New_Column varchar 20

  4. Either a or b could be used
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ALTER TABLE with ADD clause is used to add a new column to an existing table. The correct syntax is 'ALTER TABLE table_name ADD column_name datatype'. INSERT and ALTER are not used in this context.

Keep practicing — related questions