CompTIA ITF+ FC0-U61 Practice Question
You have been tasked with modifying the structure of an existing employee database to add a new column named 'PhoneNumber' that will store the employees' contact numbers. Which SQL command should you use to accomplish this task?
CREATE TABLE Employees ADD PhoneNumber VARCHAR(10);
UPDATE Employees SET PhoneNumber VARCHAR(10);
ALTER TABLE Employees ADD COLUMN PhoneNumber VARCHAR(10);
MODIFY TABLE Employees ADD COLUMN PhoneNumber VARCHAR(10);