FC0-U61 · Question #764
A database administrator needs to add a column to an existing table? Which of the following statements should the administrator use?
The correct answer is C. ALTER. To add a column to an existing table, the database administrator should use the ALTER TABLE statement with the ADD COLUMN clause. This statement allows modifying the structure of a table by adding, deleting, or changing columns and constraints. The CREATE statement is used to…
Question
A database administrator needs to add a column to an existing table? Which of the following statements should the administrator use?
Options
- ACREATE
- BUPDATE
- CALTER
- DDROP
How the community answered
(53 responses)- A4% (2)
- B2% (1)
- C89% (47)
- D6% (3)
Explanation
To add a column to an existing table, the database administrator should use the ALTER TABLE statement with the ADD COLUMN clause. This statement allows modifying the structure of a table by adding, deleting, or changing columns and constraints. The CREATE statement is used to create a new table, not to modify an existing one. The UPDATE statement is used to modify the data in a table, not the structure. The DROP statement is used to delete a table or a column, not to add a new column.
Topics
Community Discussion
No community discussion yet for this question.