CompTIA ITF+ (FC0-U61) — Question 214

A database administrator needs to add a column to an existing table? Which of the following statements should the administrator use?

Answer options

• A. CREATE
• B. UPDATE
• C. ALTER
• D. DROP

Correct answer: C

Explanation

The correct answer is C, ALTER, as it is specifically used to modify an existing database structure, including adding new columns. CREATE is used for making new tables, UPDATE is for modifying data within existing records, and DROP is used to remove tables or columns, not to add them.