Home
CompTIA
CompTIA Tech+ FC0-U71
Study Mode

CompTIA Tech+ FC0-U71 Practice Question

In an employee database, a table called 'employees' has a 'salary' field. The company policy states that no employee should have a salary lower than $30,000. Which type of constraint would be used to ensure this policy is enforced?

CHECK constraint
FOREIGN KEY constraint
PRIMARY KEY constraint
UNIQUE constraint

Next Question

Correct Incorrect Unanswered

Report Issue

Answer Description

A CHECK constraint is used to limit the range of values that can be placed in a column. If you try to insert a salary value of less than $30,000, the database will return an error because of the CHECK constraint. PRIMARY KEY constraints are used to uniquely identify each row in a table. UNIQUE constraints prevent duplicate values in a single column or combination of columns. FOREIGN KEY constraints are used to link two tables together.

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 exactly is a CHECK constraint in a database?

Open an interactive chat with Bash

How do other constraints like PRIMARY KEY and UNIQUE differ from CHECK constraints?

Open an interactive chat with Bash

What happens if I try to input a salary below $30,000 with a CHECK constraint in place?

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