Question

Which of the following statements is used to add a new column to an existing table in SQLite?

a) ALTER TABLE

b) MODIFY TABLE

c) UPDATE TABLE

d) ADD COLUMN

Answer 1

Answer: d) ADD COLUMN

Explanation: The ADD COLUMN statement is used to add a new column to an existing table in SQLite. The syntax is as follows: ALTER TABLE table_name ADD COLUMN column_name data_type;