FC0-U71 · Question #147
All relational databases utilize unique identifiers. Which of the following is the best term for an identifier?
The correct answer is C. Primary key. In relational databases, a primary key serves as a unique identifier for each row within a table.
Question
All relational databases utilize unique identifiers. Which of the following is the best term for an identifier?
Options
- AForeign key
- BRecord
- CPrimary key
- DKey/value
How the community answered
(35 responses)- A6% (2)
- C91% (32)
- D3% (1)
Why each option
In relational databases, a primary key serves as a unique identifier for each row within a table.
A foreign key is a field in one table that refers to the primary key in another table, establishing a link, but it doesn't uniquely identify rows within its own table.
A record (or row) is an entire entry of data in a table, not the identifier itself.
A primary key is a special relational database column (or combination of columns) designated to uniquely identify all information in each row of a database table. It ensures that each record can be distinctly referenced and maintains data integrity.
Key/value is a type of NoSQL database model, not the term for a unique identifier in a relational database.
Concept tested: Relational database primary keys
Source: https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.