ITPEC FE Morning October 2022 Question 27
ITPEC FE Morning October 2022 — Question 27 of 80
SQL DROP COLUMN — remove a column from an existing table.
To remove a column, use ALTER TABLE ... DROP COLUMN:
- •
ALTER TABLE table_name DROP COLUMN column_name
Why not others:
- (a) — DELETE COLUMN is not valid SQL syntax
- (c) — UPDATE modifies row data, not table structure; DELETE COLUMN is invalid
- (d) — UPDATE modifies row data, not table structure
Key rule: ALTER TABLE changes table structure (add/drop columns, rename). UPDATE changes row data. The keyword to remove a column is always DROP COLUMN, never DELETE COLUMN.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official FE past-paper collection or Report an issue.