IT Specialist – Software Development Practice Test

A primary key is the field (or combination of fields) that uniquely identifies each row in a table. Its values must be unique and not null, so no two records share the same key and every record can be precisely identified. This unique identifier is what other tables use to relate data through foreign keys, linking related data across the database. In most database systems, the primary key also gets an index to speed up lookups and enforce uniqueness, but the concept centers on identifying records, not on encryption or simple indexing; it’s distinct from a foreign key, which points to a key in another table.