How do you add a new column email VARCHAR(255) to a table users?

• A. ALTER TABLE users ADD COLUMN email VARCHAR(255);
• B. ALTER TABLE users ADD email VARCHAR(255);
• C. ALTER TABLE ADD COLUMN email VARCHAR(255) TO users;
• D. ALTER TABLE users MODIFY COLUMN email VARCHAR(255);

Answer: (A)

Adding a new column to an existing table in SQL is done with ALTER TABLE, followed by the table name, then ADD COLUMN, the new column name, and its data type. This updates the table’s schema to include the extra field so future rows can store values in that column. The exact statement to add an email column of type VARCHAR(255) to the users table is: ALTER TABLE users ADD COLUMN email VARCHAR(255); This form is correct because it clearly targets the table, introduces a new column with the specified name and data type, and uses the proper clause to create a new attribute. Other options fail because they either omit the ADD COLUMN part, place the clauses in the wrong order, or use MODIFY COLUMN, which changes an existing column rather than adding a new one.