CompTIA Study Materials
AWS Study Materials
AWS Certified Developer Associate AWS Certified Developer Associate
AWS Certified Developer Associate DVA-C02
AWS Certified Solutions Architect Associate AWS Certified Solutions Architect Associate
AWS Certified Solutions Architect Associate SAA-C03
AWS Cloud Practitioner AWS Cloud Practitioner
AWS Cloud Practitioner CLF-C02
Microsoft Study Materials
Microsoft Azure Fundamentals Microsoft Azure Fundamentals
Microsoft Azure Fundamentals AZ-900

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?

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

  • CREATE TABLE Employees ADD PhoneNumber VARCHAR(10);

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

  • UPDATE Employees SET PhoneNumber VARCHAR(10);

This question is for objective:
Database Fundamentals
Your Score:
Database Fundamentals
Infrastructure
Applications and Software
Software Development Concepts
Security
IT Concepts and Terminology