You have a table named Customer. You need to add a new column named District.
Which statement should you use?
98-364 Exam QuestionsBrowse all questions from this exam
98-364 Exam - Question 51
Show AnswerHide Answer
Correct Answer: D
To add a new column to an existing table, the correct SQL statement is to use the ALTER TABLE command followed by ADD. This syntax is used to add new columns to an existing table structure. Therefore, the correct statement is ALTER TABLE Customer ADD (District INTEGER).
Discussion
1 commentdr7401
Sep 30, 2021ADD is used to add new column,MODIFY for modifying existing column.