CompTIA
FC0-U71 · Question #1
Given the following table: Which of the following fields best represents a primary key?
The correct answer is A. ID. The ID field contains unique values for each record and is typically used as a primary key in a database. A primary key uniquely identifies each row in a table. Month, Day, Year, and Name may have duplicates and do not guarantee uniqueness.
Data and Database Fundamentals
Question
Given the following table:
Which of the following fields best represents a primary key?
Exhibit
Options
- AID
- BMonth
- CDay
- DYear
- EName
How the community answered
(65 responses)- A94% (61)
- B3% (2)
- C2% (1)
- E2% (1)
Explanation
The ID field contains unique values for each record and is typically used as a primary key in a database. A primary key uniquely identifies each row in a table. Month, Day, Year, and Name may have duplicates and do not guarantee uniqueness.
Topics
#Primary Key#Database Concepts#Relational Databases#Table Structure
Community Discussion
No community discussion yet for this question.