Q54
What SQL command can be used to add columns to a table?
A.
ALTER TABLE TableName ADD ColumnName
AnswerB.
ALTER TABLE TableName ADD COLUMN ColumnName
C.
MODIFY TABLE TableName ADD ColumnName
D.
MODIFY TABLE TableName ADD COLUMN ColumnName
Answer: Option A
Solution
Answer: Option A
Solution:
To add columns to a table in SQL, you can use the ALTER TABLE TableName ADD ColumnName command. Option A is the correct choice for adding new columns to an existing table. Options B, C, and D do not represent the standard SQL syntax for adding columns.