Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

06 Dec 2023

Posted on:

03 Dec 2023

0

Resolved: Primary Key is not obligatory in a table

When comparing PK vs Unique Key, in the number of keys (per table), PK should be 0, 1, instead of only 1, Right?

1 answers ( 1 marked as helpful)
Instructor
Posted on:

06 Dec 2023

0

Hi Jorge!
Thanks for reaching out.


A table in a database can have either 0 or 1 primary key (PK). This primary key can be a single column or a composite key consisting of multiple columns. However, regardless of being single or composite, there can only be one primary key per table.


Hope this helps.
Best,
Tsvetelin

Submit an answer