A database administrator is tasked with designing a new table in a relational database that holds customer account information. The administrator must ensure that every row in the table has a unique, non-null identifier for each customer. Which type of constraint should the administrator use to enforce this rule?
The correct answer is Primary key constraint. A primary key constraint uniquely identifies each row in a database table and cannot be null, guaranteeing that every record has a distinct identifier. A Unique constraint ensures that all values in a column are different but may still permit null values, depending on the DBMS. A Foreign key constraint is used to maintain referential integrity between two tables rather than enforce uniqueness within one table. A Check constraint validates that column values satisfy a specified predicate but does not enforce uniqueness or automatically prohibit nulls.
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 a primary key in a relational database?
Open an interactive chat with Bash
How is a primary key different from a unique constraint?
Open an interactive chat with Bash
Can a foreign key act as a unique identifier like a primary key?
Open an interactive chat with Bash
CompTIA ITF+ FC0-U61 (V5)
Database Fundamentals
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .