Question

The primary key is chosen from ________.

• A. The most complex candidate key available.
• B. All available candidate keys for a table
• C. The simplest candidate key available.
• D. Any attribute within the table

Answer 1

The Correct Option is C

A database's primary key is crucial for ensuring each record in a table is uniquely identifiable. When multiple candidate keys exist for selection, the primary key is usually chosen based on its simplicity and efficiency. A candidate key is a collection of attributes capable of uniquely identifying a row (tuple) within a table.

The appropriate selection from the given choices is: The simplest available candidate key. This principle dictates that among the candidate keys, the one with the most straightforward structure and the fewest attributes is typically favored as the primary key. This preference for simplicity enhances database performance and simplifies data management.