A ……………. is used to uniquely identify all table records.Foreign KeyPrimary KeyComposite KeyDerived Key

Step 1: Break Down the Problem

We need to identify which term among the options provided is used to uniquely identify all records in a database table.

Step 2: Relevant Concepts

In database management:

• Primary Key: A unique identifier for a record in a table. No two rows can have the same primary key value.
• Foreign Key: A field (or collection of fields) in one table that refers to the primary key in another table, used to establish a relationship between the two tables.
• Composite Key: A primary key that consists of two or more columns that together uniquely identify a record in a table.
• Derived Key: Generally refers to a key that is created from existing data rather than being explicitly defined.

Step 3: Analysis and Detail

Among the options provided, the Primary Key is specifically designed to uniquely identify each record in a table. Other options either represent relationships between tables (Foreign Key), a combination of fields (Composite Key), or keys that are not explicitly defined (Derived Key).

Step 4: Verify and Summarize

The primary key is the only option that directly matches the criterion of uniquely identifying all records within a single table.

Final Answer

The term that is used to uniquely identify all table records is Primary Key.