Free 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?

  • MODIFY TABLE Employees ADD COLUMN PhoneNumber VARCHAR(10);

  • ALTER TABLE Employees ADD COLUMN PhoneNumber VARCHAR(10);

  • UPDATE Employees SET PhoneNumber VARCHAR(10);

  • CREATE TABLE Employees ADD PhoneNumber VARCHAR(10);

This question's topic:
CompTIA ITF+ FC0-U61 / 
Database Fundamentals
Your Score:

Check or uncheck an objective to set which questions you will receive.