Database Fundamentals — Question 35

Which command should you use to add a column to an existing table?

Answer options

• A. MODIFY
• B. ALTER
• C. UPDATE
• D. INSERT
• E. CHANGE

Correct answer: B

Explanation

The correct answer is B, ALTER, which is the SQL command used to modify an existing table structure, including adding new columns. Options A (MODIFY), C (UPDATE), D (INSERT), and E (CHANGE) do not perform the action of adding a column to a table; instead, they serve different purposes such as changing data or altering rows.