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);
The ALTER TABLE command is used to modify the existing structure of a database table, such as adding a new column. In this scenario, the correct command to add a new column to an existing table is ALTER TABLE Employees ADD COLUMN PhoneNumber VARCHAR(10);. The incorrect options presented involve either SQL commands for other operations or incorrect syntax.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does the ALTER TABLE command do in SQL?
Open an interactive chat with Bash
What does VARCHAR(10) mean in SQL?
Open an interactive chat with Bash
Why can’t MODIFY or UPDATE be used to add a new column?
Open an interactive chat with Bash
CompTIA ITF+ FC0-U61 (V5)
Database Fundamentals
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .