CompTIA ITF+ FC0-U61 Practice Question
Your company is developing a new client tracking system, and you have been given the task of creating a new table within the database to store basic client information such as 'ClientID', 'ClientName', and 'ContactNumber'. Which statement would you use to initially set up this table?
ALTER TABLE Clients ADD COLUMN (ClientID int, ClientName varchar(255), ContactNumber varchar(255));
CREATE DATABASE Clients (ClientID int, ClientName varchar(255), ContactNumber varchar(255));
INSERT INTO Clients (ClientID, ClientName, ContactNumber) VALUES (1, 'Example Name', '123-456-7890');
CREATE TABLE Clients (ClientID int, ClientName varchar(255), ContactNumber varchar(255));