Home
CompTIA
CompTIA Tech+ FC0-U71
Study Mode

CompTIA Tech+ FC0-U71 Practice Question

A company wants to store information about its employees in a database. As part of setting up the database, which command would be used initially to create a new table to hold the employee data?

CREATE DATABASE
CREATE TABLE
ALTER TABLE
INSERT INTO

Next Question

Correct Incorrect Unanswered

Report Issue

Answer Description

The correct answer is 'CREATE TABLE'. This is because when establishing a new database, the 'CREATE TABLE' command is used to define a new table with its column definitions and data types. It sets the foundation for the data that will be stored. 'ALTER TABLE' is used to modify an existing table, not to create one. 'CREATE DATABASE' is used to create a database, not a table within a database. 'INSERT INTO' is used to add data to an existing table.

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 'CREATE TABLE' do in SQL?

Open an interactive chat with Bash

What are data types in SQL, and why are they important?

Open an interactive chat with Bash

How does the 'ALTER TABLE' command differ from 'CREATE TABLE'?

Open an interactive chat with Bash

CompTIA Tech+ FC0-U71

Data and Database Fundamentals

Your Score:

Settings & Objectives

IT Concepts and Terminology

Infrastructure

Applications and Software

Software Development Concepts

Data and Database Fundamentals

Security

Random Mode

Random Mixed

Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.

Rotate by Objective

Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Hide Score

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

Wipe Score

Report Issue

Bash, the Crucial Exams Chat Bot

AI Bot