A Level Computer Science OCR Practice Exam 2026 - Free Practice Questions and Study Guide

A primary key serves as a critical component in a database by ensuring that each record within a table is uniquely identifiable. This uniqueness is essential for maintaining data integrity and facilitating efficient data retrieval and manipulation. By designating a primary key for a table, you enable the database management system to distinguish between different records and prevent any ambiguity that could arise from duplicate data.

For example, in a table containing user information, the primary key might be the user's ID number. This ensures that even if two users have the same name, each record can still be accessed and managed individually without confusion. The primary key also establishes relationships between tables, which is fundamental in relational databases, as it helps organize and reference data effectively across different tables. Thus, option B accurately defines the primary key's essential role in database design and functionality.