DS0-001 · Question #85
DS0-001 Question #85: Real Exam Question with Answer & Explanation
The correct answer is A: Primary Key. A Primary Key is a column (or combination of columns) that uniquely identifies each row in a table - exactly what Howard needs to ensure no two customers share the same identifier. A Foreign Key (C) is wrong because it links rows between tables rather than uniquely identifying ro
Question
Howard is a database designer for an e-commerce website working on creating a table to store customer information. He wants to ensure that each customer can be uniquely identified within the table. Which database concept should Jack use to accomplish this goal?
Options
- APrimary Key
- BTuple
- CForeign Key
- DRelation
Explanation
A Primary Key is a column (or combination of columns) that uniquely identifies each row in a table - exactly what Howard needs to ensure no two customers share the same identifier. A Foreign Key (C) is wrong because it links rows between tables rather than uniquely identifying rows within one. A Tuple (B) refers to a single row/record in a table, not a mechanism for uniqueness. A Relation (D) is simply the formal term for the table itself, not a constraint or identifier.
Memory tip: Think "Primary = #1 = one-of-a-kind" - the primary key is the one value that makes each record stand out from all others in its table.
Community Discussion
No community discussion yet for this question.