Home
CompTIA
CompTIA Tech+ FC0-U71
Study Mode

CompTIA Tech+ FC0-U71 Practice Question

A new employee is instructed to create a new table in the company's database to track employee training records. Which SQL statement should they use to accomplish this task?

ALTER TABLE
INSERT INTO
SELECT
CREATE TABLE

Next Question

Correct Incorrect Unanswered

Report Issue

Answer Description

The correct answer is CREATE TABLE because this SQL statement is used to define a new table within a database. The other options are incorrect: ALTER TABLE is used to modify an existing table, INSERT INTO is used to add new rows of data to a table, and SELECT is used to retrieve data from a 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 is SQL and why is it important?

Open an interactive chat with Bash

What does 'CREATE TABLE' do in SQL?

Open an interactive chat with Bash

What are the differences between 'ALTER TABLE' and '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