Question

In a relational database, a key that uniquely identifies a record is called:

• A. Duplicate
• B. Foreign
• C. Secondary
• D. Primary

Hint:

Exam Tip:
Database keys:

• Primary Key: Unique identifier.
• Foreign Key: Establishes relationships.
• Candidate Key: Could be a primary key.

Answer 1

The Correct Option is D

Step 1: Understanding the Concept:
In relational databases, keys are used to uniquely identify records and establish relationships.

Step 2: Key Definitions:

• Primary Key: Uniquely identifies each record in a table. It cannot be null.
• Foreign Key: A field in one table that refers to the primary key of another table.
• Secondary Key: An index used for searching, not necessarily unique.

Step 3: Final Answer:
Therefore, option (D) is correct.