Asimple primary keyconsists ofonly one columnthat uniquely identifies each row in a table.
Example Usage:
sql
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
Name VARCHAR(50)
);
StudentIDis asimple primary keybecause it consists of only one field.
Why Other Options Are Incorrect:
Option B (Partition) (Incorrect):Refers topartitioned tables, which divide data for performance reasons butare not related to primary keys.
Option C (Stable) (Incorrect):This is not a recognized term in database keys.
Option D (Meaningless) (Incorrect):Primary keys are oftenmeaningless (e.g., auto-incremented IDs), but this isnot a term used to describe their structure.
Thus, the correct answer isSimple, as asingle-field primary keyis referred to as asimple primary key.
[Reference:SQL Primary Keys., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit