Database Fundamentals — Question 29

You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?

Answer options

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

Correct answer: A

Explanation

The correct answer is A, ALTER, as it is specifically designed for modifying the structure of a database object, including renaming columns. Options B (INSERT) and C (CREATE) are used for adding data and creating new tables, respectively, while D (UPDATE) is used to modify existing data within a table.