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?
UNIQUE constraint
CHECK constraint
FOREIGN KEY constraint
PRIMARY KEY constraint
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.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.