A field that gives each record a unique identity is called as:

2023

A field that gives each record a unique identity is called as:

  1. A.

    Unique key

  2. B.

    First key

  3. C.

    Primary key

  4. D.

    Candidate key

Attempted by 2428 students.

Show answer & explanation

Correct answer: C

In a database, a field that uniquely identifies each record is known as a primary key. It ensures that no two records have the same value in this field and does not allow NULL values. Let's understand the options: Unique key: Ensures uniqueness but allows NULL values, so it is not the best choice for a mandatory unique identity. First key: This is not a standard database term and does not exist in database design. Primary key: Guarantees uniqueness and does not allow NULL values, making it the correct choice for uniquely identifying each record. Candidate key: Can uniquely identify records but is not the primary choice for defining a unique identity field. Therefore, the correct answer is the primary key.

Explore the full course: Hpsc Pgt Computer Science