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

  • INSERT INTO Clients (ClientID, ClientName, ContactNumber) VALUES (1, 'Example Name', '123-456-7890');

  • CREATE TABLE Clients (ClientID int, ClientName varchar(255), ContactNumber varchar(255));

  • ALTER TABLE Clients ADD COLUMN (ClientID int, ClientName varchar(255), ContactNumber varchar(255));

  • CREATE DATABASE Clients (ClientID int, ClientName varchar(255), ContactNumber varchar(255));

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

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

Wipe Score
SAVE $17
CompTIA IT Fundamentals Voucher (ITF+ FC0-U61)
$138.00 $121.00